Scripts

Note that a user for the used SCHEMA and the tablespaces must exist before running the script. The minimum Oracle Role is 'RESOURCE'. See the 'create_user_tablespace.ddl' file which can serve as an example for creating the user and the tablespaces.

Best practice:

1. Open a command window and change the directory to: <VALUEMATION_HOME>\script\scriptfiles
2. Start SQL*Plus and connect with userID of the used SCHEMA, for example: C:\> sqlplus.exe USERNAME@ORACLE_HOST
3. Start the logfile: SQL>spool<file-name>
4. Start the masterscript, for example:

   SQL> @valuemation_setup_BASE.sql (*)

   SQL> @valuemation_setup_DEMO.sql (**)

5. Close the logfile: SQL> spool off

Explanatory notes: (*) Standard database: All metadata, only basic VM users, only basic demo data. (**) Demo database: All metadata, more VM users for demo, all starting demo data.