Home » RDBMS Server » Server Utilities » importing dump file error (oracle 10g windows xp)
importing dump file error [message #566565] Mon, 17 September 2012 10:16 Go to next message
mrdb
Messages: 60
Registered: December 2009
Location: dubai
Member

IMP-00017: following statement failed with ORACLE error 942:
"CREATE DIMENSION "PROMOTIONS_DIM" LEVEL "PROMO" IS ("PROMOTIONS"."PROMO_ID""
") LEVEL "SUBCATEGORY" IS ("PROMOTIONS"."PROMO_SUBCATEGORY_ID") LEVEL "CATEG"
"ORY" IS ("PROMOTIONS"."PROMO_CATEGORY_ID") LEVEL "PROMO_TOTAL" IS ("PROMOTI"
"ONS"."PROMO_TOTAL_ID") HIERARCHY "PROMO_ROLLUP" ("PROMO" CHILD OF "SUBCATEG"
"ORY" CHILD OF "CATEGORY" CHILD OF "PROMO_TOTAL") ATTRIBUTE "PROMO" LEVEL "P"
"ROMO" DETERMINES "PROMOTIONS"."PROMO_NAME" ATTRIBUTE "PROMO" LEVEL "PROMO" "
"DETERMINES "PROMOTIONS"."PROMO_END_DATE" ATTRIBUTE "PROMO" LEVEL "PROMO" DE"
"TERMINES "PROMOTIONS"."PROMO_BEGIN_DATE" ATTRIBUTE "PROMO" LEVEL "PROMO" DE"
"TERMINES "PROMOTIONS"."PROMO_COST" ATTRIBUTE "SUBCATEGORY" LEVEL "SUBCATEGO"
"RY" DETERMINES "PROMOTIONS"."PROMO_SUBCATEGORY" ATTRIBUTE "CATEGORY" LEVEL "
""CATEGORY" DETERMINES "PROMOTIONS"."PROMO_CATEGORY" ATTRIBUTE "PROMO_TOTAL""
" LEVEL "PROMO_TOTAL" DETERMINES "PROMOTIONS"."PROMO_TOTAL""
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE DIMENSION "CHANNELS_DIM" LEVEL "CHANNEL" IS ("CHANNELS"."CHANNEL_ID""
") LEVEL "CHANNEL_CLASS" IS ("CHANNELS"."CHANNEL_CLASS_ID") LEVEL "CHANNEL_T"
"OTAL" IS ("CHANNELS"."CHANNEL_TOTAL_ID") HIERARCHY "CHANNEL_ROLLUP" ("CHANN"
"EL" CHILD OF "CHANNEL_CLASS" CHILD OF "CHANNEL_TOTAL") ATTRIBUTE "CHANNEL" "
"LEVEL "CHANNEL" DETERMINES "CHANNELS"."CHANNEL_DESC" ATTRIBUTE "CHANNEL_CLA"
"SS" LEVEL "CHANNEL_CLASS" DETERMINES "CHANNELS"."CHANNEL_CLASS" ATTRIBUTE ""
"CHANNEL_TOTAL" LEVEL "CHANNEL_TOTAL" DETERMINES "CHANNELS"."CHANNEL_TOTAL""
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE DIMENSION "CUSTOMERS_DIM" LEVEL "CUSTOMER" IS ("CUSTOMERS"."CUST_ID""
") LEVEL "CITY" IS ("CUSTOMERS"."CUST_CITY_ID") LEVEL "STATE" IS ("CUSTOMERS"
""."CUST_STATE_PROVINCE_ID") LEVEL "COUNTRY" IS ("COUNTRIES"."COUNTRY_ID") L"
"EVEL "SUBREGION" IS ("COUNTRIES"."COUNTRY_SUBREGION_ID") LEVEL "REGION" IS "
"("COUNTRIES"."COUNTRY_REGION_ID") LEVEL "GEOG_TOTAL" IS ("COUNTRIES"."COUNT"
"RY_TOTAL_ID") LEVEL "CUST_TOTAL" IS ("CUSTOMERS"."CUST_TOTAL_ID") HIERARCHY"
" "CUST_ROLLUP" ("CUSTOMER" CHILD OF "CITY" CHILD OF "STATE" CHILD OF "CUST_"
"TOTAL") HIERARCHY "GEOG_ROLLUP" ("CUSTOMER" CHILD OF "CITY" CHILD OF "STATE"
"" CHILD OF "COUNTRY" CHILD OF "SUBREGION" CHILD OF "REGION" CHILD OF "GEOG_"
"TOTAL" JOIN KEY ("CUSTOMERS"."COUNTRY_ID") REFERENCES "COUNTRY") ATTRIBUTE "
""CUSTOMER" LEVEL "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_FIRST_NAME" ATTRIB"
"UTE "CUSTOMER" LEVEL "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_EMAIL" ATTRIBU"
"TE "CUSTOMER" LEVEL "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_MAIN_PHONE_NUMB"
"ER" ATTRIBUTE "CUSTOMER" LEVEL "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_POST"
"AL_CODE" ATTRIBUTE "CUSTOMER" LEVEL "CUSTOMER" DETERMINES "CUSTOMERS"."CUST"
"_STREET_ADDRESS" ATTRIBUTE "CUSTOMER" LEVEL "CUSTOMER" DETERMINES "CUSTOMER"
"S"."CUST_CREDIT_LIMIT" ATTRIBUTE "CUSTOMER" LEVEL "CUSTOMER" DETERMINES "CU"
"STOMERS"."CUST_INCOME_LEVEL" ATTRIBUTE "CUSTOMER" LEVEL "CUSTOMER" DETERMIN"
"ES "CUSTOMERS"."CUST_YEAR_OF_BIRTH" ATTRIBUTE "CUSTOMER" LEVEL "CUSTOMER" D"
"ETERMINES "CUSTOMERS"."CUST_MARITAL_STATUS" ATTRIBUTE "CUSTOMER" LEVEL "CUS"
"TOMER" DETERMINES "CUSTOMERS"."CUST_GENDER" ATTRIBUTE "CUSTOMER" LEVEL "CUS"
"TOMER" DETERMINES "CUSTOMERS"."CUST_LAST_NAME" ATTRIBUTE "CITY" LEVEL "CITY"
"" DETERMINES "CUSTOMERS"."CUST_CITY" ATTRIBUTE "STATE" LEVEL "STATE" DETERM"
"INES "CUSTOMERS"."CUST_STATE_PROVINCE" ATTRIBUTE "COUNTRY" LEVEL "COUNTRY" "
"DETERMINES "COUNTRIES"."COUNTRY_NAME" ATTRIBUTE "COUNTRY" LEVEL "COUNTRY" D"
"ETERMINES "COUNTRIES"."COUNTRY_ISO_CODE" ATTRIBUTE "SUBREGION" LEVEL "SUBRE"
"GION" DETERMINES "COUNTRIES"."COUNTRY_SUBREGION" ATTRIBUTE "REGION" LEVEL ""
"REGION" DETERMINES "COUNTRIES"."COUNTRY_REGION" ATTRIBUTE "GEOG_TOTAL" LEVE"
"L "GEOG_TOTAL" DETERMINES "COUNTRIES"."COUNTRY_TOTAL" ATTRIBUTE "CUST_TOTAL"
"" LEVEL "CUST_TOTAL" DETERMINES "CUSTOMERS"."CUST_TOTAL""
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE DIMENSION "PRODUCTS_DIM" LEVEL "PRODUCT" IS ("PRODUCTS"."PROD_ID") L"
"EVEL "SUBCATEGORY" IS ("PRODUCTS"."PROD_SUBCATEGORY_ID") LEVEL "CATEGORY" I"
"S ("PRODUCTS"."PROD_CATEGORY_ID") LEVEL "PROD_TOTAL" IS ("PRODUCTS"."PROD_T"
"OTAL_ID") HIERARCHY "PROD_ROLLUP" ("PRODUCT" CHILD OF "SUBCATEGORY" CHILD O"
"F "CATEGORY" CHILD OF "PROD_TOTAL") ATTRIBUTE "PRODUCT" LEVEL "PRODUCT" DET"
"ERMINES "PRODUCTS"."PROD_NAME" ATTRIBUTE "PRODUCT" LEVEL "PRODUCT" DETERMIN"
"ES "PRODUCTS"."PROD_MIN_PRICE" ATTRIBUTE "PRODUCT" LEVEL "PRODUCT" DETERMIN"
"ES "PRODUCTS"."PROD_LIST_PRICE" ATTRIBUTE "PRODUCT" LEVEL "PRODUCT" DETERMI"
"NES "PRODUCTS"."PROD_STATUS" ATTRIBUTE "PRODUCT" LEVEL "PRODUCT" DETERMINES"
" "PRODUCTS"."PROD_PACK_SIZE" ATTRIBUTE "PRODUCT" LEVEL "PRODUCT" DETERMINES"
" "PRODUCTS"."PROD_UNIT_OF_MEASURE" ATTRIBUTE "PRODUCT" LEVEL "PRODUCT" DETE"
"RMINES "PRODUCTS"."PROD_WEIGHT_CLASS" ATTRIBUTE "PRODUCT" LEVEL "PRODUCT" D"
"ETERMINES "PRODUCTS"."PROD_DESC" ATTRIBUTE "SUBCATEGORY" LEVEL "SUBCATEGORY"
"" DETERMINES "PRODUCTS"."PROD_SUBCATEGORY" ATTRIBUTE "SUBCATEGORY" LEVEL "S"
"UBCATEGORY" DETERMINES "PRODUCTS"."PROD_SUBCATEGORY_DESC" ATTRIBUTE "CATEGO"
"RY" LEVEL "CATEGORY" DETERMINES "PRODUCTS"."PROD_CATEGORY" ATTRIBUTE "CATEG"
"ORY" LEVEL "CATEGORY" DETERMINES "PRODUCTS"."PROD_CATEGORY_DESC" ATTRIBUTE "
""PROD_TOTAL" LEVEL "PROD_TOTAL" DETERMINES "PRODUCTS"."PROD_TOTAL""
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE DIMENSION "TIMES_DIM" LEVEL "DAY" IS ("TIMES"."TIME_ID") LEVEL "MONT"
"H" IS ("TIMES"."CALENDAR_MONTH_ID") LEVEL "QUARTER" IS ("TIMES"."CALENDAR_Q"
"UARTER_ID") LEVEL "YEAR" IS ("TIMES"."CALENDAR_YEAR_ID") LEVEL "FIS_WEEK" I"
"S ("TIMES"."WEEK_ENDING_DAY_ID") LEVEL "FIS_MONTH" IS ("TIMES"."FISCAL_MONT"
"H_ID") LEVEL "FIS_QUARTER" IS ("TIMES"."FISCAL_QUARTER_ID") LEVEL "FIS_YEAR"
"" IS ("TIMES"."FISCAL_YEAR_ID") HIERARCHY "CAL_ROLLUP" ("DAY" CHILD OF "MON"
"TH" CHILD OF "QUARTER" CHILD OF "YEAR") HIERARCHY "FIS_ROLLUP" ("DAY" CHILD"
" OF "FIS_WEEK" CHILD OF "FIS_MONTH" CHILD OF "FIS_QUARTER" CHILD OF "FIS_YE"
"AR") ATTRIBUTE "DAY" LEVEL "DAY" DETERMINES "TIMES"."DAY_NUMBER_IN_WEEK" AT"
"TRIBUTE "DAY" LEVEL "DAY" DETERMINES "TIMES"."CALENDAR_WEEK_NUMBER" ATTRIBU"
"TE "DAY" LEVEL "DAY" DETERMINES "TIMES"."DAY_NUMBER_IN_MONTH" ATTRIBUTE "DA"
"Y" LEVEL "DAY" DETERMINES "TIMES"."DAY_NAME" ATTRIBUTE "MONTH" LEVEL "MONTH"
"" DETERMINES "TIMES"."CALENDAR_MONTH_DESC" ATTRIBUTE "MONTH" LEVEL "MONTH" "
"DETERMINES "TIMES"."END_OF_CAL_MONTH" ATTRIBUTE "MONTH" LEVEL "MONTH" DETER"
"MINES "TIMES"."DAYS_IN_CAL_MONTH" ATTRIBUTE "MONTH" LEVEL "MONTH" DETERMINE"
"S "TIMES"."CALENDAR_MONTH_NAME" ATTRIBUTE "MONTH" LEVEL "MONTH" DETERMINES "
""TIMES"."CALENDAR_MONTH_NUMBER" ATTRIBUTE "QUARTER" LEVEL "QUARTER" DETERMI"
"NES "TIMES"."CALENDAR_QUARTER_DESC" ATTRIBUTE "QUARTER" LEVEL "QUARTER" DET"
"ERMINES "TIMES"."END_OF_CAL_QUARTER" ATTRIBUTE "QUARTER" LEVEL "QUARTER" DE"
"TERMINES "TIMES"."DAYS_IN_CAL_QUARTER" ATTRIBUTE "QUARTER" LEVEL "QUARTER" "
"DETERMINES "TIMES"."CALENDAR_QUARTER_NUMBER" ATTRIBUTE "YEAR" LEVEL "YEAR" "
"DETERMINES "TIMES"."CALENDAR_YEAR" ATTRIBUTE "YEAR" LEVEL "YEAR" DETERMINES"
" "TIMES"."END_OF_CAL_YEAR" ATTRIBUTE "YEAR" LEVEL "YEAR" DETERMINES "TIMES""
"."DAYS_IN_CAL_YEAR" ATTRIBUTE "FIS_WEEK" LEVEL "FIS_WEEK" DETERMINES "TIMES"
""."WEEK_ENDING_DAY" ATTRIBUTE "FIS_WEEK" LEVEL "FIS_WEEK" DETERMINES "TIMES"
""."FISCAL_WEEK_NUMBER" ATTRIBUTE "FIS_MONTH" LEVEL "FIS_MONTH" DETERMINES ""
"TIMES"."FISCAL_MONTH_DESC" ATTRIBUTE "FIS_MONTH" LEVEL "FIS_MONTH" DETERMIN"
"ES "TIMES"."END_OF_FIS_MONTH" ATTRIBUTE "FIS_MONTH" LEVEL "FIS_MONTH" DETER"
"MINES "TIMES"."DAYS_IN_FIS_MONTH" ATTRIBUTE "FIS_MONTH" LEVEL "FIS_MONTH" D"
"ETERMINES "TIMES"."FISCAL_MONTH_NAME" ATTRIBUTE "FIS_MONTH" LEVEL "FIS_MONT"
"H" DETERMINES "TIMES"."FISCAL_MONTH_NUMBER" ATTRIBUTE "FIS_QUARTER" LEVEL ""
"FIS_QUARTER" DETERMINES "TIMES"."FISCAL_QUARTER_DESC" ATTRIBUTE "FIS_QUARTE"
"R" LEVEL "FIS_QUARTER" DETERMINES "TIMES"."END_OF_FIS_QUARTER" ATTRIBUTE "F"
"IS_QUARTER" LEVEL "FIS_QUARTER" DETERMINES "TIMES"."DAYS_IN_FIS_QUARTER" AT"
"TRIBUTE "FIS_QUARTER" LEVEL "FIS_QUARTER" DETERMINES "TIMES"."FISCAL_QUARTE"
"R_NUMBER" ATTRIBUTE "FIS_YEAR" LEVEL "FIS_YEAR" DETERMINES "TIMES"."FISCAL_"
"YEAR" ATTRIBUTE "FIS_YEAR" LEVEL "FIS_YEAR" DETERMINES "TIMES"."END_OF_FIS_"
"YEAR" ATTRIBUTE "FIS_YEAR" LEVEL "FIS_YEAR" DETERMINES "TIMES"."DAYS_IN_FIS"
"_YEAR""
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
About to enable constraints...
Import terminated successfully with warnings.


===============
i got this error when i am importing a dump file

any suggestion pls
Re: importing dump file error [message #566567 is a reply to message #566565] Mon, 17 September 2012 10:23 Go to previous messageGo to next message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The tables underlying the dimension do not exist.
Either they are not present and not imported, either there has been an error during the import of these tables.

Regards
Michel
Re: importing dump file error [message #566568 is a reply to message #566567] Mon, 17 September 2012 10:28 Go to previous messageGo to next message
mrdb
Messages: 60
Registered: December 2009
Location: dubai
Member

. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
===============
this is what log file showing when exported.
Re: importing dump file error [message #566571 is a reply to message #566568] Mon, 17 September 2012 11:10 Go to previous message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This does not show anything about the tables.

Regards
Michel
Previous Topic: sqlloader
Next Topic: expdp where clause with subquery
Goto Forum:
  


Current Time: Wed Apr 16 22:01:11 CDT 2014

Total time taken to generate the page: 0.13355 seconds