4.10 SH Sample Schema Scripts and Objects

This section lists the names of the scripts that create the Sales History (SH) schema and describes the objects in the schema. Table 4-26 lists the SH scripts in alphabetical order, while Table 4-27 lists its objects.

Table 4-26 SH Sample Schema Scripts

Script Name	Description
sh_analz.sql	Gathers statistics on the schema objects
sh_comnt.sql	Creates comments for the objects in the schema
sh_cons.sql	Modifies constraints on objects in the schema
sh_cre.sql	Creates the objects in the schema
sh_cremv.sql	Creates materialized views and bitmapped indexes
sh_drop.sql	Drops schema SH and all its objects
sh_idx.sql	Creates indexes on tables in the schema
sh_main.sql	Main script for schema SH; calls other scripts
olp_v3.sql	Creates dimensions and hierarchies used by the OLAP server
sh_olp_d.sql	Drops the objects used by the OLAP server

Table 4-27 SH Sample Schema Objects

Object Type	Objects
Dimension	CHANNELS_DIM, CUSTOMERS_DIM, PRODUCTS_DIM, PROMOTIONS_DIM, TIMES_DIM
Index	CHANNELS_PK, COSTS_PROD_BIX, COSTS_TIME_BIX, COUNTRIES_PK, CUSTOMERS_GENDER_BIX, CUSTOMERS_MARITAL_BIX, CUSTOMERS_PK, CUSTOMERS_YOB_BIX, DR$SUP_TEXT_IDX$X, FW_PSC_S_MV_CHAN_BIX, FW_PSC_S_MV_PROMO_BIX, FW_PSC_S_MV_SUBCAT_BIX, FW_PSC_S_MV_WD_BIX, PRODUCTS_PK, PRODUCTS_PROD_CAT_IX, PRODUCTS_PROD_STATUS_BIX, PRODUCTS_PROD_SUBCAT_IX, PROMO_PK, SALES_CHANNEL_BIX, SALES_CUST_BIX, SALES_PROD_BIX, SALES_PROMO_BIX, SALES_TIME_BIX, SUP_TEXT_IDX, SYS_IOT_TOP_45927, SYS_IOT_TOP_45932, TIMES_PK
Index Partition	COSTS_PROD_BIX, COSTS_TIME_BIX, SALES_CHANNEL_BIX, SALES_CUST_BIX, SALES_PROD_BIX, SALES_PROMO_BIX, SALES_TIME_BIX
Lob	SYS_LOB0000045924C00006$$, SYS_LOB0000045929C00002$$
Materialized View	CAL_MONTH_SALES_MV, FWEEK_PSCAT_SALES_MV
Table	CHANNELS, COSTS, COUNTRIES, CUSTOMERS, PRODUCTS, PROMOTIONS, SALES, TIMES
Table Partition	COSTS, SALES
View	PROFITS