| importing dump file error [message #566565] |
Mon, 17 September 2012 10:16  |
mrdb
Messages: 62
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
|
|
|
|
|
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
