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>
阅读(629) | 评论(0) | 转发(0) |