Drop Table Fails With ORA-600 [15264] [ID 338953.1]

 

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/17252115/viewspace-732961/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17252115/viewspace-732961/