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
%install_root%\Scheduler\createTablespaceOracle.ddl and %install_root%\Scheduler\createSchemaOracle.ddl
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.
sqlplus scheduser/schedpwd@scheddb @createSchemaOracle.ddlIf 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