在尝试使用expdp导出Oracle数据库时遇到了UDE-31623和ORA-31623错误。通过检查数据库日志和执行SQL命令更新obj$表，成功解决了内部错误kkdlcob-objn-exists。最终能够创建和删除表，问题得到修复。
参考文章 http://dbsnake.com/2010/08/ora-600-objn-exists.html
[oracle@HTVDB001 backup]$ expdp \' / as sysdba \' dumpfile=deploy-201109200415.dmp schemas=DEPLOY exclude=table:\" like \'V_%\'\"
Export: Release 11.2.0.1.0 - Production on Tue Sep 20 04:22:49 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4488
ORA-06512: at line 1
[oracle@HTVDB001 backup]$
[oracle@HTVDB001 backup]$
[oracle@HTVDB001 backup]$ expdp \' / as sysdba \' dumpfile=deploy-201109200415.dmp schemas=DEPLOY exclude=table:\" like \'V_%\'\"
Export: Release 11.2.0.1.0 - Production on Tue Sep 20 04:22:49 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4488
ORA-06512: at line 1
[oracle@HTVDB001 backup]$
[oracle@HTVDB001 backup]$
最低0.47元/天 解锁文章
1450
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
