Described below is the process on creating tables for application
schedulers from Oracle databases, using data definition language (DDL) or
structured query language (SQL) files.
Why and when to perform this task
Follow these steps to create a table from an Oracle database.Steps for this task
- 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.
Note: When setting the
table prefix, capitalize all characters.
%install_root%\Scheduler\createTablespaceOracle.ddl and %install_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, on Windows systems, the user ID is scheduser,
password is schedpwd, database name is scheddb,
and table space path is d:\mydb\ts. Type in 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.
For example, on Windows systems, 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
Result
The Oracle tables and schema for the application scheduler
exist.
What to do next