OE Sample Schema Scripts and Objects
The following tables list the names of the scripts that create the Order Entry
(oe
) sample schema and describe the objects in the schema.
Table 4-29 lists the oe
scripts in
alphabetical order, while Table 4-30 lists the oe
objects. Note that
language-specific statements for product names and descriptions are stored in the
following files, where each file represents a different language:
oe_p_us.sql
,
oe_p_ar.sql
, oe_p_cs.sql
,
oe_p_d.sql
, oe_p_dk.sql
,
oe_p_e.sql
, oe_p_el.sql
,
oe_p_esa.sql
, oe_p_f.sql
,
oe_p_frc.sql
, oe_p_hu.sql
,
oe_p_i.sql
, oe_p_iw.sql
,
oe_p_ja.sql
, oe_p_ko.sql
,
oe_p_n.sql
, oe_p_nl.sql
,
oe_p_pl.sql
, oe_p_pt.sql
,
oe_p_ptb.sql
, oe_p_ro.sql
,
oe_p_ru.sql
, oe_p_s.sql
,
oe_p_sf.sql
, oe_p_sk.sql
,
oe_p_th.sql
, oe_p_tr.sql
,
oe_p_zhs.sql
, oe_p_zht.sql
.
Table 4-29 OE Sample Schema Scripts
Script Name | Description |
---|---|
|
Adds comments to the online catalog ( |
|
Creates subschema |
|
Drops subschema |
|
Main script for subschema |
|
Populates the object tables |
|
Gathers statistics on the |
|
Creates comments for the objects in the schema |
|
Creates the |
|
Drops schema |
|
Creates indexes on the |
|
Main script for the |
|
Creates the |
Table 4-30 OE Sample Schema Objects
Object Type | Objects |
---|---|
Index |
|
Function |
|
Sequence |
|
Synonym |
|
Table |
|
Trigger |
|
Type |
|
Type Body |
|
View |
|