Create Oracle tables for schedulers

Create tables for schedulers on Oracle databases using DDL or SQL files.

This task requires you to configure a database and make it available. Refer to the Creating Oracle databases for schedulers topic for more information.

To create tables for schedulers on Oracle databases, using DDL or SQL files, use these steps.

1. Open a command-line window.

2. Make sure that we have administrator rights for the database system.

3. Create the table space and schema.

   1. Use a text editor, edit the following scripts according to the instructions at the top of the files.

      When setting the table prefix, capitalize all characters.

      %app_server_root%\Scheduler\createTablespaceOracle.ddl and %app_server_root%\createSchemaMod1Oracle.ddl

   2. Set the environment variable ORACLE_SID, if we do not want the schema to be created in the default instance.

   3. Run the script, createTablespaceOracle.ddl, to create the table space.

      For test purposes, use the same location for all table spaces and pass the path as a command line argument to the script.

      For example, the user ID is scheduser, password is schedpwd, database name is scheddb, and table space path is d:\mydb\ts. Enter the command: sqlplus scheduser/schedpwd@scheddb @createTablespaceOracle.ddl d:\mydb\ts If we get any errors creating the table space, we can use dropTablespaceOracle.ddl to drop the table space.

   4. Run the script, createSchemaMod1Oracle.ddl, to create the schema.

      For example, enter the following script:

      sqlplus scheduser/schedpwd@scheddb @createSchemaMod1Oracle.ddl

      If we see any errors creating the schema (tables and views), we can drop the schema by running script:

      dropSchemaMod1Oracle.ddl

Results

The Oracle tables and schema for scheduler exist.

Related tasks

Create Oracle databases for schedulers

Data source minimum required settings, by vendor