Creating Oracle tables for schedulers

This topic describes how to create tables for schedulers on Oracle databases, using data definition language (DDL) or structured query language (SQL) files.

Before you begin

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

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

  1. Open a command-line window.
  2. Make sure that you have administrator rights for the database system.
  3. Create the table space and schema.
    1. 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%\createSchemaMod1Oracle.ddl
    2. Set the environment variable ORACLE_SID, if you 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.

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

Results

The Oracle tables and schema for scheduler exist.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic    

Terms of Use | Feedback

Last updated: Oct 20, 2010 11:50:58 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-base-iseries&topic=tsch_oracleadmin
File name: tsch_oracleadmin.html