Executing database scripts (Oracle Database)

To create a repository, you must:

•	Run the load_as_sys.sql script to create the schema.

•	Run the load.sql script to create the tables etc. for the repository.

Prerequisites

•	The login details for the SYSDBA user and the schema owner are available.

•	The ZIP file with the database scripts is generated in Control Center and unpacked using an archiving application, such as WinZip.

Post requisites

•	Always do a sanity check to make sure the repository was created according to your configurations.

•	Since the scripts contain passwords, it is recommended to delete the scripts after you have created the repository.

To execute the scripts

1	Since the password of the schema owner is the same as the schema owner user name, it is recommended to change the password in the load_as_sys.sql script.

2	Open the appropriate Oracle tool. For example, Oracle® SQL Developer or SQL*Plus (requires Oracle® Database Instant Client).

3	Log in as the SYSDBA user.

4	Run the load_as_sys.sql script.

5	Log in as the schema owner configured for the repository.

6	Run the load.sql script.