4.4 OE Sample Schema Scripts and Objects

This section lists the names of the scripts that create the Order Entry (OE) sample schema and describes the objects in the schema. Table 4-10 lists the OE scripts in alphabetical order, while Table 4-11 lists its objects. Note that language-specific statements for product names and descriptions are stored in these files (each representing a different language): INSERToe_p_us.sqloe_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-10 OE Sample Schema Scripts

Script Name	Description
oc_comnt.sql	Adds comments to the online catalog (OC) subschema wherever possible
oc_cre.sql	Creates subschema OC
oc_drop.sql	Drops subschema OC
oc_main.sql	Main script for subschema OC
oc_popul.sqla	Populates the object tables
oe_analz.sql	Gathers statistics on the OE objects
oe_comnt.sql	Creates comments for the objects in the schema
oe_cre.sql	Creates the OE objects
oe_drop.sql	Drops schema OE and all its objects
oe_idx.sql	Creates indexes on the OE tables
oe_main.sql	Main script for the OE schema; calls other scripts
oe_views.sql	Creates the OE schema views

Table 4-11 OE Sample Schema Objects

Object Type	Objects
Index	CUSTOMERS_PK, CUST_ACCOUNT_MANAGER_IX, CUST_EMAIL_IX, CUST_LNAME_IX, CUST_UPPER_NAME_IX, INVENTORY_IX, INV_PRODUCT_IX, ITEM_ORDER_IX, ITEM_PRODUCT_IX, ORDER_ITEMS_PK, ORDER_ITEMS_UK, ORDER_PK, ORD_CUSTOMER_IX, ORD_ORDER_DATE_IX, ORD_SALES_REP_IX, PRD_DESC_PK, PRODUCT_INFORMATION_PK, PROD_NAME_IX, PROD_SUPPLIER_IX, PROMO_ID_PK, REFERENCE_IS_UNIQUE, SYS_C003584, SYS_C003587, SYS_C003588, SYS_C003589, SYS_C003590, WAREHOUSES_PK, WHS_LOCATION_IX
Function	GET_PHONE_NUMBER_F
Sequence	ORDERS_SEQ
Lob	SYS_LOB0000045843C00022$$, SYS_LOB0000045843C00023$$, SYS_LOB0000045852C00003$$, SYS_LOB0000045852C00012$$, SYS_LOB0000045852C00013$$, SYS_LOB0000046019C00004$$, SYS_LOB0000046019C00005$$, SYS_LOB0000046019C00007$$, SYS_LOB0000046019C00011$$, SYS_LOB0000046019C00012$$, SYS_LOB0000046019C00015$$, SYS_LOB0000046019C00024$$, SYS_LOB0000046019C00031$$, SYS_LOB0000046019C00032$$, SYS_LOB0000046044C00003$$
Synonym	COUNTRIES, DEPARTMENTS, EMPLOYEES, JOBS, JOB_HISTORY, LOCATIONS
Table	CUSTOMERS, INVENTORIES, ORDERS, ORDER_ITEMS, PRODUCT_DESCRIPTIONS, PRODUCT_INFORMATION, WAREHOUSES
Trigger	INSERT_ORD_LINE, ORDERS_ITEMS_TRG, ORDERS_TRG
Type	CATALOG_TYP, CATEGORY_TYP, COMPOSITE_CATEGORY_TYP, CORPORATE_CUSTOMER_TYP, CUSTOMER_TYP, CUST_ADDRESS_TYP, INVENTORY_LIST_TYP, INVENTORY_TYP, LEAF_CATEGORY_TYP, ORDER_ITEM_LIST_TYP, ORDER_ITEM_TYP, ORDER_LIST_TYP, ORDER_TYP, PHONE_LIST_TYP, PRODUCT_INFORMATION_TYP, PRODUCT_REF_LIST_TYP, SUBCATEGORY_REF_LIST_TYP, SYS_YOID0000046073$, SYS_YOID0000046075$, SYS_YOID0000046077$, SYS_YOID0000046079$, SYS_YOID0000046081$, WAREHOUSE_TYP, XDBPO_ACTIONS_TYPE, XDBPO_ACTION_COLLECTION, XDBPO_ACTION_TYPE, XDBPO_LINEITEMS_TYPE, XDBPO_LINEITEM_COLLECTION, XDBPO_LINEITEM_TYPE, XDBPO_PART_TYPE, XDBPO_REJECTION_TYPE, XDBPO_SHIPINSTRUCTIONS_TYPE, XDBPO_TYPE
Type Body	CATALOG_TYP, COMPOSITE_CATEGORY_TYP, LEAF_CATEGORY_TYP
View	ACCOUNT_MANAGERS, BOMBAY_INVENTORY, CUSTOMERS_VIEW, DEPTVIEW, OC_CORPORATE_CUSTOMERS, OC_CUSTOMERS, OC_INVENTORIES, OC_ORDERS, OC_PRODUCT_INFORMATION, ORDERS_VIEW, PRODUCTS, PRODUCT_PRICES, SYDNEY_INVENTORY, TORONTO_INVENTORY