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.