Drop Table Fails With ORA-600 [15264]

xiexingzhi發表於2012-12-03
原文網址 : http://blog.itpub.net/22531473/viewspace-750451/
AI
Drop Table Fails With ORA-600 [15264] [ID 338953.1]
修改時間 10-APR-2012 型別 PROBLEM 狀態 PUBLISHED
In this Document
Symptoms
Changes
Cause
Solution
References

Applies to:

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 ***
Symptoms

You tried to drop a table and the DROP TABLE SQL command failed by raising an ORA-600 [15264].

The trace file generated at that time shows:

ORA-00600: internal error code, arguments: [15264], [], [], [], [], [], [], []
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.

Changes

The drop of the table was interrupted and then reattempted.
Cause

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'.
Solution

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:

Recyclebin purged.


-> 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 [15264]

-> 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:

in 10gR1:

set the init.ora parameter "_recyclebin" = false, bounce the database and try again the same drop.

in 10gR2
Run the following command:

SQL> ALTER SESSION SET RECYCLEBIN=OFF;
and try again the same drop.

References

NOTE:265253.1 - 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[15264]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22531473/viewspace-750451/，如需轉載，請註明出處，否則將追究法律責任。

相關文章