impdp中斷導致資料庫問題的解決

使用impdp匯入資料庫，腦袋一時發熱，懷疑好像有問題，然後按了ctrl+c退出。結果不但導致impdp出現問題，還導致create table不能進行。由於是生產系統，嚇出一身冷汗。 [oracle@voddb ~]$ impdp system/xxxxx@voddb directory=expdp_dir dumpfile=oam20130605.dmp SCHEMAS=OAM REMAP_SCHEMA = OAM:OAM2Import: Release 11.2.0.1.0 - Production on Thu Jun 6 14:06:18 2013Copyright (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 optionsUDI-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 SQL> create table aaaaa(aa  varchar2(100)); create table aaaaa(aa  varchar2(100)) * ERROR at line 1: ORA-00600: internal error code, arguments: [kqlInvObj:user], [111], [], [], [], [], [], [], [], [], [], [] 網上查得： http://www.freedba.net/2010/1824.html select dataobj# from obj$ where name = '_NEXT_OBJECT'; select max(obj#) from obj$ ; 但發現 dataobj# 比 max(obj#) 大，update obj$ set dataobj#=30397】 where name = '_NEXT_OBJECT'; 也沒用。仔細查看，跟這個問題還不一樣。它報的錯誤是ORA-00600: internal error code, arguments: [kkdlcob-objn-exists], [254555], [], [], [], [], [], [], [], [], [], [] 我的後面是kqlInvObj:user，繼續用這個關鍵字查詢： http://space.itpub.net/11088128/viewspace-711751 http://blog.mchz.com.cn/?p=8433 ;，跟我的問題一樣： select * from sys.obj$where owner# in (111);      //111即報錯資訊中的資訊：[kqlInvObj:user], [111], 查到有記錄 select * from sys.user$ where user#=111; 查到無記錄，然後將上面的記錄刪除掉： delete from sys.obj$where owner# in (111); commit; 繼續create table就正常了： SQL> create table aaaaa(aa  varchar2(100)); Table created. impdp也正常了！ 慶幸！！！

本文出自 “大浪淘沙” 部落格，請務必保留此出處http://sandjj.blog.51cto.com/1141448/1293806