WebSphere Application Server Network Deployment, Version 6.0.x     Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Creating Oracle tables for schedulers

Before you begin

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

Why and when to perform this task

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

Steps for this task

  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.
      Note: When setting the table prefix, capitalize all characters.
      %install_root%\Scheduler\createTablespaceOracle.ddl and %install_root%\Scheduler\createSchemaOracle.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. 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. 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.

    4. 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 scheduler exist.



Related tasks
Creating Oracle databases for schedulers

Related reference
Vendor-specific data sources minimum required settings

Task topic    

Terms of Use | Feedback

Last updated: Mar 17, 2005 4:28:29 AM CST
http://publib.boulder.ibm.com/infocenter/ws60help/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/scheduler/tasks/tsch_oracleadmin.html

© Copyright IBM Corporation 2002, 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)