导入.dmp时出错:IMP-00003: 遇到 ORACLE 错误00942

IMP-00003:ORACLEerror942encounteredORA-00942:tableorviewdoesnotexistIMP-00017:followi... 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"" 展开

 我来答

2个回答

#热议# 为什么说不要把裤子提到肚脐眼？

理工爱好者