IMP-00003: 遇到 ORACLE 错误 600 ORA-00600: 内部错误代码
答案:2 悬赏:80
解决时间 2021-02-13 00:17
- 提问者网友：玫瑰园
- 2021-02-12 13:53
IMP-00003: 遇到 ORACLE 错误 600 ORA-00600: 内部错误代码
最佳答案
- 二级知识专家网友：十鸦
- 2021-02-12 14:12
其实这个对象是已经被删除的"BIN$JRMI0tLJT6qc9yk1lwLEFQ==$0"
你可以在源数据库 purge recyclbin, 然后再导一次看看
你可以在源数据库 purge recyclbin, 然后再导一次看看
全部回答
- 1楼网友：洎扰庸人
- 2021-02-12 15:17
"Cause: The problem is caused by a dictionary inconsistency.
When compiling invalid PL/SQL objects a corresponding row for the invalid object must exist in OBJERROR$. The ORA-600 error indicates that this row could not be updated (the "U" parameter) because the row didn't exist.
Solution: Solution is to add the missing row by querying the OBJECT_ID from DBA_OBJECTS for the object to be compiled.
Then perform an INSERT of this OBJECT_ID value into OBJERROR$.
Next is to perform COMMIT followed by a SHUTDOWN ABORT. Note that this MUST be ABORT to prevent the rowcache from being flushed to the data dictionary.
After that, the database can be started using STARTUP NORMAL and the trigger can be compiled."
可能是导入的库对应的数据字典存在讹误了，需要手动Patch数据字典修复
如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
When compiling invalid PL/SQL objects a corresponding row for the invalid object must exist in OBJERROR$. The ORA-600 error indicates that this row could not be updated (the "U" parameter) because the row didn't exist.
Solution: Solution is to add the missing row by querying the OBJECT_ID from DBA_OBJECTS for the object to be compiled.
Then perform an INSERT of this OBJECT_ID value into OBJERROR$.
Next is to perform COMMIT followed by a SHUTDOWN ABORT. Note that this MUST be ABORT to prevent the rowcache from being flushed to the data dictionary.
After that, the database can be started using STARTUP NORMAL and the trigger can be compiled."
可能是导入的库对应的数据字典存在讹误了，需要手动Patch数据字典修复
如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯