Creating the WebFOCUS UOA Repository
WebFOCUS 8 has a new architecture whereby all WebFOCUS
web-tier content is stored in an RDBMS database. This database is
referred to as the WebFOCUS UOA repository.
Procedure: How to Create the WebFOCUS UOA Repository
override the default tablespace when creating the Oracle UOA repository,
follow these steps after the WebFOCUS Client and ReportCaster installations
the Oracle DDL file as follows:
This will create a file called ddl-generation.sql in the install_directory/utilities/ WFReposUtil
For appropriate SQL statements, specify the Oracle tablespace
in which the UOA repository tables are to be created and loaded.
external tool, load the UOA repository tables to input SQL statements
from the updated ddl-generation.sql file.
to load the required WebFOCUS UOA information into the UOA repository.
the UOA repository tables were created and loaded in the Oracle
tablespace specified in the ddl-generation.sql file.