Just another Blog

My Technical, Professional and at times Personal Blog

Showing posts with label Install Oracle SH schema. Show all posts

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.

Google+ Followers