IMP-00017: 由于 ORACLE 的 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 错误 942
ORA-00942: 表或视图不存在
IMP-00017: 由于 ORACLE 的 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-00003: 遇到 ORACLE 错误 942
ORA-00942: 表或视图不存在
IMP-00017: 由于 ORACLE 的 942 错误,以下的语句失败
"CREATE DIMENSION "CHANNELS_DIM" LEVEL "CHANNEL" IS ("CHANNELS"."CHANNEL_ID""
") LEVEL "CHANNEL_CLASS" IS ("CHANNELS"."CHANNEL_CLASS") LEVEL "CHANNEL_TOTA"
"L" IS ("CHANNELS"."CHANNEL_TOTAL") HIERARCHY "CHANNEL_ROLLUP" ("CHANNEL" CH"
"ILD OF "CHANNEL_CLASS" CHILD OF "CHANNEL_TOTAL") ATTRIBUTE "CHANNEL" DETERM"
"INES "CHANNELS"."CHANNEL_DESC" ATTRIBUTE "CHANNEL_CLASS" DETERMINES "CHANNE"
"LS"."CHANNEL_CLASS" ATTRIBUTE "CHANNEL_TOTAL" DETERMINES "CHANNELS"."CHANNE"
"L_TOTAL""
IMP-00003: 遇到 ORACLE 错误 942
ORA-00942: 表或视图不存在
准备启用约束条件...
成功终止导入,但出现警告。
"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 错误 942
ORA-00942: 表或视图不存在
IMP-00017: 由于 ORACLE 的 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-00003: 遇到 ORACLE 错误 942
ORA-00942: 表或视图不存在
IMP-00017: 由于 ORACLE 的 942 错误,以下的语句失败
"CREATE DIMENSION "CHANNELS_DIM" LEVEL "CHANNEL" IS ("CHANNELS"."CHANNEL_ID""
") LEVEL "CHANNEL_CLASS" IS ("CHANNELS"."CHANNEL_CLASS") LEVEL "CHANNEL_TOTA"
"L" IS ("CHANNELS"."CHANNEL_TOTAL") HIERARCHY "CHANNEL_ROLLUP" ("CHANNEL" CH"
"ILD OF "CHANNEL_CLASS" CHILD OF "CHANNEL_TOTAL") ATTRIBUTE "CHANNEL" DETERM"
"INES "CHANNELS"."CHANNEL_DESC" ATTRIBUTE "CHANNEL_CLASS" DETERMINES "CHANNE"
"LS"."CHANNEL_CLASS" ATTRIBUTE "CHANNEL_TOTAL" DETERMINES "CHANNELS"."CHANNE"
"L_TOTAL""
IMP-00003: 遇到 ORACLE 错误 942
ORA-00942: 表或视图不存在
准备启用约束条件...
成功终止导入,但出现警告。
你还是重新从SQLServer2000导入到Oracle,注意dts过程中,将映射到oracle中的表名改成大写。
Action Check each of the following: 1.the spelling of the table or view name. 2.that a view is not specified where a table is required. 3.that an existing table or view name exists. Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table. Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted.
你的用户表成功的导入了,oracle会把你的内部表的信息写到它的数据字典表中,而user_tables等系统视图从这些系统表中筛选出相应的表,而你的表中信息如果是诸如小写、字段用了oracle关键字,都会导致在遍历数据字典过程中,出现错误!
检验是不是你dts的问题很简单,把你的dts的用户drop掉,然后exp看看能不能出错!