Oracle sample script

The Ctrain_ModelCreate_Oracle.sql file contains all the SQL required to create the database.

You can use either the Oracle Storage Manager or SQLPlus Worksheet to run the script.

You must edit the script to meet your needs. You need to change:

• File paths in the Create Tablespace sections
• Database name
• User names and passwords for the administrative users
• Database size

When you edit the script, follow these rules.

• The production user name cannot be longer than 28 characters.
• The name of the authorized user must be the production user name plus '_A.' For example, if the production user name is CTRAIN, the authorized user name must be CTRAIN_A.
• The passwords for each of these users must be the same.