Installing Oracle Sample Sales (SH) schema on XE

The short answer is, it won't work on XE. You'll need an enterprise edition.

Anyway, here is what I found:

I am on Oracle 11g XE and I couldn't locate the sh_main.sql in the ...oracle\product\11.2.0\server\demo\schema\ folder.

I downloaded the global schema 11g from here.

Uncompressed the file and ran an import of the .dmp file that was enclosed.


C:\Users\..\Downloads\global-11g-schema-1-128202>imp userid=system/<pwd>  fromuser=global touser=global file='global_11g_source.dmp' buffer=65000

Import: Release 11.2.0.2.0 - Production on Tue Nov 29 16:37:07 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
Export file created by EXPORT:V11.01.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing GLOBAL's objects into GLOBAL
. . importing table                      "ACCOUNT"         24 rows imported
. . importing table                  "CHANNEL_DIM"          3 rows imported
. . importing table                 "CUSTOMER_DIM"         61 rows imported
. . importing table                   "PRICE_FACT"       2523 rows imported
. . importing table         "PRODUCT_CHILD_PARENT"         48 rows imported
. . importing table                  "PRODUCT_DIM"         36 rows imported
. . importing table                     "TIME_DIM"        120 rows imported
. . importing table                   "UNITS_FACT"     299446 rows imported
IMP-00017: following statement failed with ORACLE error 439:
 "CREATE BITMAP INDEX "UNITS_FACT_IDX_1" ON "UNITS_FACT" ("MONTH_ID" )  PCTFR"
 "EE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 917504 FREELISTS 1 FREELIST G"
 "ROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Bit-mapped indexes
IMP-00017: following statement failed with ORACLE error 20000:
 "BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"UNITS_FACT_IDX_1"',NULL,NULL,NULL,"
 "203,99,108,1,1,203,1,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "GLOBAL"."UNITS_FACT_IDX_1" does not exist or insufficient priv
ileges
ORA-06512: at "SYS.DBMS_STATS", line 4455
ORA-06512: at "SYS.DBMS_STATS", line 9464
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 439:
 "CREATE BITMAP INDEX "UNITS_FACT_IDX_2" ON "UNITS_FACT" ("ITEM_ID" )  PCTFRE"
 "E 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 196608 FREELISTS 1 FREELIST GR"
 "OUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Bit-mapped indexes
IMP-00017: following statement failed with ORACLE error 20000:
 "BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"UNITS_FACT_IDX_2"',NULL,NULL,NULL,"
 "43,17,36,1,1,43,1,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "GLOBAL"."UNITS_FACT_IDX_2" does not exist or insufficient priv
ileges
ORA-06512: at "SYS.DBMS_STATS", line 4455
ORA-06512: at "SYS.DBMS_STATS", line 9464
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 439:
 "CREATE BITMAP INDEX "UNITS_FACT_IDX_3" ON "UNITS_FACT" ("SHIP_TO_ID" )  PCT"
 "FREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 1 FREELIST"
 " GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Bit-mapped indexes
IMP-00017: following statement failed with ORACLE error 20000:
 "BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"UNITS_FACT_IDX_3"',NULL,NULL,NULL,"
 "61,8,61,1,1,61,1,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "GLOBAL"."UNITS_FACT_IDX_3" does not exist or insufficient priv
ileges
ORA-06512: at "SYS.DBMS_STATS", line 4455
ORA-06512: at "SYS.DBMS_STATS", line 9464
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 439:
 "CREATE BITMAP INDEX "UNITS_FACT_IDX_4" ON "UNITS_FACT" ("CHANNEL_ID" )  PCT"
 "FREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 1 FREELIST"
 " GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING"
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Bit-mapped indexes
IMP-00017: following statement failed with ORACLE error 20000:
 "BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"UNITS_FACT_IDX_4"',NULL,NULL,NULL,"
 "15,8,3,2,5,15,1,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "GLOBAL"."UNITS_FACT_IDX_4" does not exist or insufficient priv
ileges
ORA-06512: at "SYS.DBMS_STATS", line 4455
ORA-06512: at "SYS.DBMS_STATS", line 9464
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 439:
 "CREATE DIMENSION "CHANNEL_DIMENSION" LEVEL "TOTAL" IS ("CHANNEL_DIM"."TOTAL"
 "_ID") LEVEL "CHANNEL" IS ("CHANNEL_DIM"."CHANNEL_ID") HIERARCHY "PRIMARY" ("
 ""CHANNEL" CHILD OF "TOTAL") ATTRIBUTE "TOTAL" LEVEL "TOTAL" DETERMINES "CHA"
 "NNEL_DIM"."TOTAL_DSC" ATTRIBUTE "CHANNEL" LEVEL "CHANNEL" DETERMINES "CHANN"
 "EL_DIM"."CHANNEL_DSC""
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Materialized view rewrite
IMP-00017: following statement failed with ORACLE error 439:
 "CREATE DIMENSION "CUSTOMER_DIMENSION" LEVEL "TOTAL" IS ("CUSTOMER_DIM"."TOT"
 "AL_ID") LEVEL "REGION" IS ("CUSTOMER_DIM"."REGION_ID") LEVEL "WAREHOUSE" IS"
 " ("CUSTOMER_DIM"."WAREHOUSE_ID") LEVEL "MARKET_SEGMENT" IS ("CUSTOMER_DIM"."
 ""MARKET_SEGMENT_ID") LEVEL "account" IS ("CUSTOMER_DIM"."ACCOUNT_ID") LEVEL"
 " "SHIP_TO" IS ("CUSTOMER_DIM"."SHIP_TO_ID") HIERARCHY "SHIPMENTS" ("SHIP_TO"
 "" CHILD OF "WAREHOUSE" CHILD OF "REGION" CHILD OF "TOTAL") HIERARCHY "segme"
 "nt" ("SHIP_TO" CHILD OF "account" CHILD OF "MARKET_SEGMENT" CHILD OF "TOTAL"
 "") ATTRIBUTE "TOTAL" LEVEL "TOTAL" DETERMINES "CUSTOMER_DIM"."TOTAL_DSC" AT"
 "TRIBUTE "REGION" LEVEL "REGION" DETERMINES "CUSTOMER_DIM"."REGION_DSC" ATTR"
 "IBUTE "WAREHOUSE" LEVEL "WAREHOUSE" DETERMINES "CUSTOMER_DIM"."WAREHOUSE_DS"
 "C" ATTRIBUTE "MARKET_SEGMENT" LEVEL "MARKET_SEGMENT" DETERMINES "CUSTOMER_D"
 "IM"."MARKET_SEGMENT_DSC" ATTRIBUTE "account" LEVEL "account" DETERMINES "CU"
 "STOMER_DIM"."ACCOUNT_DSC" ATTRIBUTE "SHIP_TO" LEVEL "SHIP_TO" DETERMINES "C"
 "USTOMER_DIM"."SHIP_TO_DSC""
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Materialized view rewrite
IMP-00017: following statement failed with ORACLE error 439:
 "CREATE DIMENSION "PRODUCT_DIMENSION" LEVEL "TOTAL" IS ("PRODUCT_DIM"."TOTAL"
 "_ID") LEVEL "class" IS ("PRODUCT_DIM"."CLASS_ID") LEVEL "FAMILY" IS ("PRODU"
 "CT_DIM"."FAMILY_ID") LEVEL "ITEM" IS ("PRODUCT_DIM"."ITEM_ID") HIERARCHY "p"
 "rimary" ("ITEM" CHILD OF "FAMILY" CHILD OF "class" CHILD OF "TOTAL") ATTRIB"
 "UTE "TOTAL" LEVEL "TOTAL" DETERMINES "PRODUCT_DIM"."TOTAL_DSC" ATTRIBUTE "c"
 "lass" LEVEL "class" DETERMINES "PRODUCT_DIM"."CLASS_DSC" ATTRIBUTE "FAMILY""
 " LEVEL "FAMILY" DETERMINES "PRODUCT_DIM"."FAMILY_DSC" ATTRIBUTE "ITEM" LEVE"
 "L "ITEM" DETERMINES "PRODUCT_DIM"."ITEM_DSC""
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Materialized view rewrite
IMP-00017: following statement failed with ORACLE error 439:
 "CREATE DIMENSION "TIME_DIMENSION" LEVEL "TOTAL" IS ("TIME_DIM"."TOTAL_ID") "
 "LEVEL "CALENDAR_YEAR" IS ("TIME_DIM"."CALENDAR_YEAR_ID") LEVEL "CALENDAR_QU"
 "ARTER" IS ("TIME_DIM"."CALENDAR_QUARTER_ID") LEVEL "FISCAL_YEAR" IS ("TIME_"
 "DIM"."FISCAL_YEAR_ID") LEVEL "FISCAL_QUARTER" IS ("TIME_DIM"."FISCAL_QUARTE"
 "R_ID") LEVEL "month" IS ("TIME_DIM"."MONTH_ID") HIERARCHY "CALENDAR" ("mont"
 "h" CHILD OF "CALENDAR_QUARTER" CHILD OF "CALENDAR_YEAR" CHILD OF "TOTAL") H"
 "IERARCHY "FISCAL" ("month" CHILD OF "FISCAL_QUARTER" CHILD OF "FISCAL_YEAR""
 " CHILD OF "TOTAL") ATTRIBUTE "TOTAL" LEVEL "TOTAL" DETERMINES "TIME_DIM"."T"
 "OTAL_DSC" ATTRIBUTE "CALENDAR_YEAR" LEVEL "CALENDAR_YEAR" DETERMINES "TIME_"
 "DIM"."CALENDAR_YEAR_DSC" ATTRIBUTE "CALENDAR_QUARTER" LEVEL "CALENDAR_QUART"
 "ER" DETERMINES "TIME_DIM"."CALENDAR_QUARTER_DSC" ATTRIBUTE "FISCAL_YEAR" LE"
 "VEL "FISCAL_YEAR" DETERMINES "TIME_DIM"."FISCAL_YEAR_DSC" ATTRIBUTE "FISCAL"
 "_QUARTER" LEVEL "FISCAL_QUARTER" DETERMINES "TIME_DIM"."FISCAL_QUARTER_DSC""
 " ATTRIBUTE "month" LEVEL "month" DETERMINES "TIME_DIM"."MONTH_DSC""
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Materialized view rewrite
About to enable constraints...
Import terminated successfully with warnings.