当前位置: 代码迷 >> Oracle管理 >> 导入.dmp时出错:IMP-00003: 遇到 ORACLE 异常 942
  详细解决方案

导入.dmp时出错:IMP-00003: 遇到 ORACLE 异常 942

热度:786   发布时间:2016-04-24 05:17:26.0
导入.dmp时出错:IMP-00003: 遇到 ORACLE 错误 942
。。。。。。。。。。。。。

. 正在将PANDA的对象导入到 PANDA 
. . 正在导入表 "ADMININFO" 27行被导入 
. . 正在导入表 "DEALRECORD_PRO" 1行被导入 
. . 正在导入表 "DEALRECORD_USER" 0行被导入 
. . 正在导入表 "FAVORITE" 13行被导入 
. . 正在导入表 "ORDERINFO_PRO" 41行被导入 
. . 正在导入表 "ORDERINFO_USER" 26行被导入 
. . 正在导入表 "PRODUCTINFO" 56行被导入 
. . 正在导入表 "PRODUCTTYPE" 16行被导入 
. . 正在导入表 "SHOPPINGBAG" 3行被导入 
. . 正在导入表 "USERINFO" 33行被导入 
IMP-00017: 由于 ORACLE 的 942 错误,以下的语句失败 
 "CREATE DIMENSION "CUSTOMERS_DIM" LEVEL "CUSTOMER" IS ("CUSTOMERS"."CUST_ID"" 
 ") LEVEL "CITY" IS ("CUSTOMERS"."CUST_CITY") LEVEL "STATE" IS ("CUSTOMERS"."" 
 "CUST_STATE_PROVINCE") LEVEL "COUNTRY" IS ("COUNTRIES"."COUNTRY_ID") LEVEL "" 
 "SUBREGION" IS ("COUNTRIES"."COUNTRY_SUBREGION") LEVEL "REGION" IS ("COUNTRI" 
 "ES"."COUNTRY_REGION") LEVEL "GEOG_TOTAL" IS ("COUNTRIES"."COUNTRY_TOTAL") L" 
 "EVEL "CUST_TOTAL" IS ("CUSTOMERS"."CUST_TOTAL") HIERARCHY "CUST_ROLLUP" ("C" 
 "USTOMER" CHILD OF "CITY" CHILD OF "STATE" CHILD OF "CUST_TOTAL") HIERARCHY " 
 ""GEOG_ROLLUP" ("CUSTOMER" CHILD OF "CITY" CHILD OF "STATE" CHILD OF "COUNTR" 
 "Y" CHILD OF "SUBREGION" CHILD OF "REGION" CHILD OF "GEOG_TOTAL" JOIN KEY ("" 
 "CUSTOMERS"."COUNTRY_ID") REFERENCES "COUNTRY") ATTRIBUTE "CUSTOMER" DETERMI" 
 "NES "CUSTOMERS"."CUST_FIRST_NAME" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMER" 
 "S"."CUST_EMAIL" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_MAIN_PHON" 
 "E_NUMBER" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_POSTAL_CODE" AT" 
 "TRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_STREET_ADDRESS" ATTRIBUTE "" 
 "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_CREDIT_LIMIT" ATTRIBUTE "CUSTOMER" D" 
 "ETERMINES "CUSTOMERS"."CUST_INCOME_LEVEL" ATTRIBUTE "CUSTOMER" DETERMINES "" 
 "CUSTOMERS"."CUST_YEAR_OF_BIRTH" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"" 
 "."CUST_MARITAL_STATUS" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_GE" 
 "NDER" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_LAST_NAME" ATTRIBUT" 
 "E "CITY" DETERMINES "CUSTOMERS"."CUST_CITY" ATTRIBUTE "STATE" DETERMINES "C" 
 "USTOMERS"."CUST_STATE_PROVINCE" ATTRIBUTE "COUNTRY" DETERMINES "COUNTRIES"." 
 ""COUNTRY_NAME" ATTRIBUTE "SUBREGION" DETERMINES "COUNTRIES"."COUNTRY_SUBREG" 
  相关解决方案