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. 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.

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.sql	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

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
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