ORACLE ORA-00600 错误解决
现象,在一台新服务器的新oracle11g数据库里,创建物化视图或者创建表,
ORA-00600: internal error code, arguments: [kkdlcob-objn-exists], [254555], [], [], [], [], [], [], [], [], [], []
解决方法:
修改obj$表中的dataobj#值大于max(obj#)即可!
具体操作如下:
SQL>select dataobj# from sys.obj$ where name = '_NEXT_OBJECT'; DATAOBJ# ---------- 12345 SQL>select max(obj#) from sys.obj$ ; MAX(OBJ#) ---------- 170660 SQL>update sys.obj$ set dataobj#=170661 where name = '_NEXT_OBJECT'; SQL>commit;