在做一次数据迁移,把原来在windows平台下的oracle9201的库迁至aix下10204中。导出时无错误,导入的时候报错,以下是报错信息:
IMP-00017: 由于 ORACLE 的 604 错误,以下的语句失败
"CREATE SEQUENCE "HIBERNATE_SEQUENCE" MINVALUE 1 MAXVALUE 999999999999999999"
"999999999 INCREMENT BY 1 START WITH 19421 CACHE 20 NOORDER NOCYCLE"
IMP-00003: 遇到 ORACLE 错误 604
ORA-00604: error occurred at recursive SQL level 1
ORA-20000: Trigger xdb_installation_trigger does not support object creation of type SEQUENCE
ORA-06512: at line 32
后经过对比原库和新库发现有sequence未能在新库中导入,后在新库中手动建sequence,却又报出以下错误:
ORA-00604: error occurred at recursive SQL level 1
ORA-20000: Trigger xdb_installation_trigger does not support object creation of type SEQUENCE
发现跟导入时的错误一致,后通过google查询了一下错误,说是递归某个SQL 层时出现错误,但是找不到具体解决方案,请各位帮帮忙,来诊断一下。
原帖由 ZALBB 于 2009-8-21 11:36 发表
alter system set events '604 trace name errorstack level 1'
IMP--until meet 604 error.
alter system set events '604 trace name errorstack off';
请问下5楼的大哥,您是说的是604错误的解决方案还是说我有过这个操作而引起的错误呢。
原帖由 ZALBB 于 2009-8-21 11:36 发表
alter system set events '604 trace name errorstack level 1'
IMP--until meet 604 error.
alter system set events '604 trace name errorstack off';
谢谢这位大哥,安装您的指点,已经把trace文件抓取了下来,这里列出来,您帮忙看一下,谢谢了!
*** ACTION NAME
) 2009-08-21 14:14:03.564
*** MODULE NAME
SQL*Plus) 2009-08-21 14:14:03.564
*** SERVICE NAME
SYS$USERS) 2009-08-21 14:14:03.564
*** SESSION ID
303.19) 2009-08-21 14:14:03.564
*** 2009-08-21 14:14:03.564
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-20000: Trigger xdb_installation_trigger does not support object creation of type SEQUENCE
ORA-06512: at line 32
Current SQL statement for this session:
CREATE SEQUENCE "HIBERNATE_SEQUENCE" MINVALUE 1 MAXVALUE 999999999999999999
INCREMENT BY 1 START WITH 19421 CACHE 20 NOORDER NOCYCLE
----- Call Stack Trace -----
calling
call entry
argument values in hex
location
type point
(? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst+001c
bl ksedst1
000000000 ? 000000000 ?
ksedmp+0290
bl ksedst
104A2C630 ?
ksddoa+02e8
bl _ptrgl