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.
x
Procedure: How to Create the WebFOCUS UOA Repository
Note: To
override the default tablespace when creating the Oracle UOA repository,
follow these steps after the WebFOCUS Client and ReportCaster installations
are complete.
-
Generate
the Oracle DDL file as follows:
-
Run install_directory/utilities/WFReposUtil/WFReposUtilCreateDDL.sh.
This will create a file called ddl-generation.sql in the install_directory/utilities/
WFReposUtil directory.
-
Update the
ddl-generation.sql file:
-
For appropriate SQL statements, specify the Oracle tablespace
in which the UOA repository tables are to be created and loaded.
-
Using an
external tool, load the UOA repository tables to input SQL statements
from the updated ddl-generation.sql file.
-
Run install_directory/utilities/WFReposUtil/WFReposUtilLoad.sh
to load the required WebFOCUS UOA information into the UOA repository.
-
Verify that
the UOA repository tables were created and loaded in the Oracle
tablespace specified in the ddl-generation.sql file.