Start SQL Developer or SQL*Plus Worksheet. Your Oracle user must
have the DBA role granted.
Open a query window and paste in the contents of the database
name_ ViewIntitialize_Oracle.sql script. For example:
CPMViews_ViewInitialize_Oracle.sql
Execute the script.
Repeat steps 2 and 3 for the database name_ ViewDefine_Oracle.sql
script. For example:
CPMViews_ViewDefine_Oracle.sql
If you are creating the database for the first time, you will see
a message when running this script. The script drops the tables and a message
will display if the tables do not exist. The database is setup properly and the
message can be ignored.
Open the
Manage Data Sources page and add a data source
for the Views database.
Run the Views database utility and import view content.
If you are overwriting an existing database, you can skip steps 2 and
3.