This topic describes how to create tables for schedulers on Oracle
databases, using data definition language (DDL) or structured query language
(SQL) files.
About this task
To create tables for schedulers on Oracle databases, using data definition
language (DDL) or structured query language (SQL) files, use these steps.
Procedure
- Open a command-line window.
- Make sure that you have administrator rights for the database system.
- Create the table space and schema.
- Using a text editor, edit the following scripts according to
the instructions at the top of the files.
Tip: When
setting the table prefix, capitalize all characters.
%app_server_root%\Scheduler\createTablespaceOracle.ddl and %app_server_root%\Scheduler\createSchemaOracle.ddl
- Set the environment variable ORACLE_SID, if you do
not want the schema to be created in the default instance.
- 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 you get any errors creating
the table space, you can use dropTablespaceOracle.ddl to drop the
table space.
- Run the script, createSchemaOracle.ddl, to create the
schema.
![[Windows]](../../windows.gif)
For example, enter the following
script:
sqlplus scheduser/schedpwd@scheddb @createSchemaOracle.ddl
If
you see any errors creating the schema (tables and views), you can drop the
schema by running script:
dropSchemaOracle.ddl
Results
The Oracle tables and schema for scheduler exist.