ORA-600(12804)错误

Oracle 9208 RAC for AIX出现这个错误。
错误信息为:

Tue Jun 22 17:41:21 2010
Errors IN file /oracle/app/admin/orcl/udump/orcl2_ora_4293428.trc:
ORA-00600: internal error code, arguments: [12804], [kkdlgtd: bad object TYPE], [], [], [], [], [], []
Tue Jun 22 17:41:22 2010
Trace dumping IS performing id=[cdmp_20100622174122]

从错误信息上分析,这个问题发生在Oracle检查对象类型时。查询MOS文档ORA-600 [12804] [kkdlgtd: bad object type] Alter Table Add Column Or Running a Query [ID 468435.1],导致问题的原因可能有两个,一个是由于DBA_OBJECTS中缺少了对象的信息,另一个是由于在执行DDL语句的时候没有指定OWNER。
解决方法就是在OBJECT前面添加OWNER,从而避免找不到对象所引发的600错误。

This entry was posted in BUG and tagged , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *