- 论坛徽章:
- 0
|
我用exp备份了一个用户的数据,用 imp导入,都是9i
导入好像倒是成功了,但是总会出这个报错:
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") LEVEL "CATEGORY" IS ("
""PRODUCTS"."PROD_CATEGORY") LEVEL "PROD_TOTAL" IS ("PRODUCTS"."PROD_TOTAL")"
" HIERARCHY "PROD_ROLLUP" ("PRODUCT" CHILD OF "SUBCATEGORY" CHILD OF "CATEGO"
"RY" CHILD OF "PROD_TOTAL") ATTRIBUTE "PRODUCT" DETERMINES "PRODUCTS"."PROD_"
"NAME" ATTRIBUTE "PRODUCT" DETERMINES "PRODUCTS"."PROD_MIN_PRICE" ATTRIBUTE "
""PRODUCT" DETERMINES "PRODUCTS"."PROD_LIST_PRICE" ATTRIBUTE "PRODUCT" DETER"
"MINES "PRODUCTS"."PROD_STATUS" ATTRIBUTE "PRODUCT" DETERMINES "PRODUCTS"."P"
"ROD_PACK_SIZE" ATTRIBUTE "PRODUCT" DETERMINES "PRODUCTS"."PROD_UNIT_OF_MEAS"
"URE" ATTRIBUTE "PRODUCT" DETERMINES "PRODUCTS"."PROD_WEIGHT_CLASS" ATTRIBUT"
"E "PRODUCT" DETERMINES "PRODUCTS"."PROD_DESC" ATTRIBUTE "SUBCATEGORY" DETER"
"MINES "PRODUCTS"."PROD_SUBCATEGORY" ATTRIBUTE "SUBCATEGORY" DETERMINES "PRO"
"DUCTS"."PROD_SUBCAT_DESC" ATTRIBUTE "CATEGORY" DETERMINES "PRODUCTS"."PROD_"
"CATEGORY" ATTRIBUTE "CATEGORY" DETERMINES "PRODUCTS"."PROD_CAT_DESC" ATTRIB"
"UTE "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 "PROMOTIONS_DIM" LEVEL "PROMO" IS ("PROMOTIONS"."PROMO_ID""
") LEVEL "SUBCATEGORY" IS ("PROMOTIONS"."PROMO_SUBCATEGORY") LEVEL "CATEGORY"
"" IS ("PROMOTIONS"."PROMO_CATEGORY") LEVEL "PROMO_TOTAL" IS ("PROMOTIONS".""
"PROMO_TOTAL") HIERARCHY "PROMO_ROLLUP" ("PROMO" CHILD OF "SUBCATEGORY" CHIL"
"D OF "CATEGORY" CHILD OF "PROMO_TOTAL") ATTRIBUTE "PROMO" DETERMINES "PROMO"
"TIONS"."PROMO_NAME" ATTRIBUTE "PROMO" DETERMINES "PROMOTIONS"."PROMO_END_DA"
"TE" ATTRIBUTE "PROMO" DETERMINES "PROMOTIONS"."PROMO_BEGIN_DATE" ATTRIBUTE "
""PROMO" DETERMINES "PROMOTIONS"."PROMO_COST" ATTRIBUTE "SUBCATEGORY" DETERM"
"INES "PROMOTIONS"."PROMO_SUBCATEGORY" ATTRIBUTE "CATEGORY" DETERMINES "PROM"
"OTIONS"."PROMO_CATEGORY" ATTRIBUTE "PROMO_TOTAL" DETERMINES "PROMOTIONS"."P"
"ROMO_TOTAL""
有很多,基本都是这个格式,节选了一部分。
查到说这种情况,可以先导入结构,在导入数据,用了这个方法
imp xxx/xxx file=empdata.dmp rows=N fromuser=xxx touser=xxx
imp xxx/xxx file=empdata.dmp fromuser=xxx touser=xxx
也还是同样的错误,而且在导入结构时就报这个 表或视图不存在 的错误。
虽然好象是导入成功了,但是有这么多报错总觉得不舒服,请告人给指点一下。 谢谢了先。 |
|