求助: ORA-00604: 递归 SQL 层 1 出现错误(刚才的贴,我回复不了了)
当我对一个表 select 的时候,可以查询出数据来。
但是当我 insert 或者 delete 的时候,就会报错:
insert into cjd (id,zcjd,ajbh) values ('1252145','1','152452')
*
ERROR 位于第 1 行:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-00942: 表或视图不存在
我oracle是8i,数据库是 用 8i 导的 10g ,然后又导进 8i 里的。
用户都一样,表空间不一样。这个有关系吗?临时表空间也不一样。
导入的时候,报错了,错误信息我也记不太清了,说什么缺少关键字。
但是,不是导入触发器,或者序列什么的错误,这些都成功导入。
有的表就可以insert 有的就不可以。
这是我导入表的日志,大家可以帮我看一下吗?
用 8i 从 10g到处的时候,没有错误。
再导入 8i 的时候 就报错了。
连接到: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
经由常规路径导出由EXPORT:V08.01.07创建的文件
已经完成ZHS16GBK字符集和ZHS16GBK NCHAR 字符集中的导入
导出服务器使用UTF8 NCHAR 字符集 (可能的ncharset转换)
. 正在将LFTEST的对象导入到 LFTEST
. . 正在导入表 "ZZSL_HH" 3行被导入
. . 正在导入表 "DQSBM_HH" 16行被导入
. . 正在导入表 "CJDW" 94行被导入
// 太长了,不让回复 省略了一部分,都是 导入表,没警告。
. . 正在导入表 "CJD" 167209行被导入
. . 正在导入表 "ADDRESSLIST" 0行被导入
IMP-00017: 由于 ORACLE 错误905,以下的语句失败
"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 错误905出现
ORA-00905: 缺少关键字
IMP-00017: 由于 ORACLE 错误905,以下的语句失败
"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 错误905出现
ORA-00905: 缺少关键字
IMP-00017: 由于 ORACLE 错误905,以下的语句失败
"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 错误905出现
ORA-00905: 缺少关键字
IMP-00017: 由于 ORACLE 错误905,以下的语句失败
"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 错误905出现
ORA-00905: 缺少关键字
IMP-00017: 由于 ORACLE 错误905,以下的语句失败
"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 错误905出现
ORA-00905: 缺少关键字
准备启用约束条件...
成功终止导入,但出现警告。