Dbca creating the human resources hr sample schema

This section describes how to install the Sample Schemas manually.

Schema Dependencies

Various dependencies have been established among the schemas. Therefore, when you create the schemas manually, you must create them in the following order: HR , OE , PM , IX , and SH .

Use this sequence to create the schemas:

1. Create the HR schema.
2. Create the OE schema: The HR schema must already be present, and you must know the password for the HR schema so that you can grant HR object privileges to OE . Some HR tables are visible to the OE user through the use of private synonyms. In addition, some OE tables have foreign key relationships to HR tables.

Installing the Human Resources (HR) Schema

All scripts necessary to create this schema reside in $ORACLE_HOME/demo/schema/human_resources .

You need to call only one script, hr_main.sql , to create all objects and load the data. Running hr_main.sql accomplishes the following tasks:

1. Prompts for passwords and tablespace names used within the scripts.
2. Removes any previously installed HR schema.
3. Creates the user HR and grants the necessary privileges.
4. Connects as HR .
5. Calls the scripts that create and populate the schema objects.

For a complete listing of the scripts and their functions, please refer to Table 4-1.

A pair of optional scripts, hr_dn_c.sql and hr_dn_d.sql , is provided as a schema extension. To prepare the Human Resources schema for use with the Directory capabilities of Oracle Internet Directory, run the hr_dn_c.sql create script. If you want to return to the initial setup of the HR schema, use the script hr_dn_d.sql to reverse the effects of hr_dn_c.sql and remove the column added by this extension.

The file used to drop the HR schema is hr_drop.sql .

Installing the Order Entry (OE) Schema and its Online Catalog (OC) Subschema

All scripts necessary to create this schema reside in $ORACLE_HOME/demo/schema/order_entry .

You need to call only one script, oe_main.sql , to create all objects and load the data. Running oe_main.sql accomplishes the following tasks:

1. Prompts for passwords and tablespace names used within the scripts.
2. Removes any previously installed OE schema.
3. Creates the user OE and grants the necessary privileges.
4. Connects as OE .
5. Calls the scripts that create and populate the schema objects.

For a complete listing of the scripts and their functions, please refer to Table 4-2.

The files used to drop the OE schema and OC subschema are oe_drop.sql and oc_drop.sql .

Installing the Product Media (PM) Schema

All files necessary to create this schema reside in $ORACLE_HOME/demo/schema/product_media .

You need to call only one script, pm_main.sql , to create all objects and load the data. Running pm_main.sql accomplishes the following tasks:

1. Prompts for passwords and tablespace names used within the scripts, as well as datafile and log file directories.
2. Removes any previously installed PM schema.
3. Creates the user PM and grants the necessary privileges.
4. Connects as PM .
5. Calls the following scripts that create and populate the schema objects.

For a complete listing of the scripts and their functions, please refer to Table 4-3.

The file used to drop the PM schema is pm_drop.sql .

Note:

Installing the Information Exchange (IX) Schema

All files necessary to create this schema reside in $ORACLE_HOME/demo/schema/info_exchange .

You need to call only one script, ix_main.sql , to create all objects and load the data. Running ix_main.sql accomplishes the following tasks:

1. Prompts for passwords and tablespace names used within the scripts.
2. Removes any previously installed IX schema.
3. Creates the user IX and grants the necessary privileges.
4. Connects as IX .
5. Calls the scripts that create and populate the schema.

For a complete listing of the scripts and their functions, please refer to Table 4-4.

The file used for dropping all queues in an orderly fashion is ix_drop.sql .

Installing the Sales History (SH) Schema

All files necessary to create this schema reside in $ORACLE_HOME/demo/schema/sales_history .

You need to call only one script, sh_main.sql , to create all objects and load the data. Running sh_main.sql accomplishes the following tasks:

1. Prompts for passwords and tablespace names used within the scripts, as well as datafile and log file directories.
2. Removes any previously installed SH schema.
3. Creates the user SH and grants the necessary privileges.
4. Connects as SH .
5. Calls the scripts that create and populate the schema objects.

For a complete listing of the scripts and their functions, please refer to Table 4-5.

Note:

A pair of optional scripts, sh_olp_c.sql and sh_olp_d.sql , is provided as a schema extension. To prepare the Sales History schema for use with the advanced analytic capabilities of OLAP Services, run the sh_olp_c.sql create script. If you want to return to the initial setup of the SH schema, use the script sh_olp_d.sql to erase the effects of sh_olp_c.sql and reinstate dimensions as they were before.

The file used to drop the SH schema is sh_drop.sql .