Oracle® Database Sample Schemas 10g Release 1 (10.1) Part Number B10771-01 |
|
|
View PDF |
Each schema has two primary scripts:
One script resets and creates all objects and data for a particular schema. This script is named xx
_main.sql
, where xx
is the schema abbreviation. This main script calls all other scripts necessary to build and load the schema.
One script removes all objects from a particular schema. This script is named xx
_drop.sql
, where xx
is the schema abbreviation.
The Sample Schemas script directories are located in $ORACLE_HOME/demo/schema
.
Note: This chapter does not include the scripts themselves, because they are very lengthy. |