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.2Information 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:
This will purge your recycle bin and should return the following message:
-> 2/ Being logged as sysdba, execute now the following SQL command:
This purges the DBA recycle bin and returns the following message:
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:
-> 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:
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Drop Table Fails With ORA-600 [15264]AI
- drop table和truncate table的區別
- flashback drop/query/table/database/archiveDatabaseHive
- How To Efficiently Drop A Table With Many Extents
- oracle 誤刪表 drop tableOracle
- drop apply INSTANTIATION for one tableAPP
- audit drop table為什麼不行
- Drop table cascade constraintsAI
- [doc]How To Efficiently Drop A Table With Many Extents
- Oracle10g 回收站及徹底刪除table : drop table xx purge 以及drop flashOracle
- 深入解析 oracle drop table內部原理Oracle
- DROP TABLE ** CASCADE CONSTRAINTS PURGEAI
- "DROP USER" fails with error: ORA-00942 and ORA-00604 (一)AIError
- "DROP USER" fails with error: ORA-00942 and ORA-00604 (二)AIError
- MySQL資料災難挽救之drop tableMySql
- MySQL 5.6 drop database時,table metadata lock等待MySqlDatabase
- Backup And Recovery User's Guide-使用閃回刪除來回退DROP TABLE操作GUIIDE
- Truncate table 詳解及與delete,drop 的區別delete
- Truncate table詳解及與delete,drop的區別delete
- 資料庫審計(create/alter/drop table、user、tablespace)資料庫
- v$lock之alter table drop column與alter table set unused column區別系列五
- Unable To Mount Or Drop A Diskgroup, Fails With Ora-15032 And Ora-15063_353423.1AI
- oracle drop table purge無備份bbed恢復(1/3)Oracle
- oracle drop table purge無備份bbed恢復(2/3)Oracle
- oracle drop table purge無備份bbed恢復(3/3)Oracle
- 外來鍵約束drop table cascade constraintsAI
- 主子表drop table constraints cascade的測試AI
- 執行drop table base purge出現ora_00604
- MySQL DROP TABLE刪除表報錯'ERROR 1051 (42S02): Unknown table'MySqlError
- linux下修改drop_cache引數觸發ORA-600 [KGHLKREM1]LinuxREM
- Oracle10g 回收站及徹底刪除table : drop table xx purge 以及flashbackOracle
- 執行create table as 報ora-600的錯誤的解決方案
- 閃回之 回收站、Flashback Drop (table、index、trigger等)Index
- maridb Error 'Operation DROP USER failed forErrorAI
- ORA-600(kjxgrdecidemem1)錯誤IDE
- ORA-600(kfioUnidentify01)錯誤IDE
- DataGridView with multiple tableView
- ORA-00904: "DROP_SEGMENTS": invalid identifierIDE