drop table ora-600 15264

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

 

该错误通常是由于表的索引异常导致的，删除索引时提示没有该索引，因此导致ora-600错误

 

解决方法如下：
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;

最后删除成功

SQL> drop table dbtest.stat_channel_common_1300;

Table dropped.

SQL>