|Drop Table Fails With ORA-600  [ID 338953.1]|
||修改时间 10-APR-2012 类型 PROBLEM 状态 PUBLISHED
In this Document
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.5 - Release: 10.1 to 10.2
Information in this document applies to any platform.
*** Checked for relevance on 10-APR-2012 ***
You tried to drop a table and the DROP TABLE SQL command failed by raising an ORA-600 .
The trace file generated at that time shows:
ORA-00600: internal error code, arguments: , , , , , , , 
Current SQL statement for this session:
drop table ...
And Call Stack contains:
... kkdldidRecycle ...
Trying to drop the indexes may give ORA-01418: specified index does not exist.
The drop of the table was interrupted and then reattempted.
The exact cause is not all identified but this has most probably to do with the 10g recyclebin.
Bugs have been logged for similar issues, but closed with a status 'could not reproduce'.
Although the root cause is unknown, we suggest that you:
-> 1/ Log as sysdba and execute the following SQL command:
SQL> PURGE RECYCLEBIN;
This will purge your recycle bin and should return the following message:
-> 2/ Being logged as sysdba, execute now the following SQL command:
SQL> PURGE DBA_RECYCLEBIN;
This purges the DBA recycle bin and returns the following message:
DBA Recyclebin purged.
Then, you should be able to remove the table without encountering the ORA-600 
-> 3/ In other words, re-try the same operation that failed earlier:
SQL> DROP TABLE ... ;
-> 4/ If this still fails, bounce (shutdown & restart) the database and retry again the same drop command.
-> 5/ If the database bounce did not help:
set the init.ora parameter "_recyclebin" = false, bounce the database and try again the same drop.
Run the following command:
SQL> ALTER SESSION SET RECYCLEBIN=OFF;
and try again the same drop.
- 10g Recyclebin Features And How To Disable it( _recyclebin )NOTE:278623.1
- imdinst.sql=ORA=29809, deinssdo.sql=ORA-2303, drop user MDSYS=ORA-600
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17252115/viewspace-732961/，如需转载，请注明出处，否则将追究法律责任。