Creating an Oracle Database Schema
- Matthew Wren
The database schema can be created in one of two ways: either from a database dump provided by ServicePower, or from scratch. These two mutually exclusive methods are described in the following sections.
Pre-populated Schema dump available
Import database dump file (from the /server directory) into required user.
The actual command used to achieve this will depend on how the original database dump was taken. Your DBAs need to work with your ServicePower Consultants to determine which is best for your environment and reference should be made to the Oracle on line documentation on the subject (http://docs.oracle.com/cd/B28359_01/index.htm).
Once this is decided, ServicePower consultants will provide a database export using the agreed toolset.
Starting from 'scratch'
Create an empty Oracle user with the appropriate privileges (see Creating an Oracle Database User). See Note 1, below, regarding populating the user with 'own' database objects not part of the ServiceScheduling schema.
Import the database export file into the schema created in step 2, above.
Note 1
The user created in step 1, above, must not contain any user objects. You may create other schema objects of your own, not used by ServiceScheduling, but you must import the database export as prescribed in step 2, above, before creating any schema objects of your own.
What are the parameters for dbinstall to create and empty schema only?
dbinstall -d <databaseConnectionString> \ --create-schema-only --create-user \ --dba-user <dba user> --dba-password <dba password> \ --tablespace <tablespace>