Why and when to perform this task
There is no script to quickly create a default Oracle database for process choreographer.Steps for this task
lsnrctl start
On Windows systems, enter:
cd install_root\ProcessChoreographer
On UNIX systems, enter:
cd install_root/ProcessChoreographer
sqlplus bpeuser/bpepwd@BPEDB @createTablespaceOracle8.ddl d:\mydb\tsIf you want to drop the table spaces, you can use the dropTablespaceOracleX.ddl script, where 'X' is your Oracle version digit (8 or 9).
sqlplus bpeuser/bpepwd@BPEDB @createSchemaOracle9.ddlIf you want to drop the schema use the clearSchemaOracleX.ddl script to clear the schema, and the dropSchemaOracleX.ddl script to drop the schema.
Results
The Oracle database for process choreographer exists.