승적이익강 (勝敵而益强)

[Oracle]ORA-600: Internal error code, arguments:[kqlInvObj:user]. 본문

Database

[Oracle]ORA-600: Internal error code, arguments:[kqlInvObj:user].

그녕이 2016. 5. 4. 10:22

create table AUDIT_ACTIONS(
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kqlInvObj:user]


$ impdp system/xxxxx@UAT dumpfile=oam20130605.dmp SCHEMAS=APM 


Import: Release 11.2.0.1.0 - Production on Thu Jun 6 14:06:18 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
UDI-00018: Data Pump client is incompatible with database version 11.2.0.1.0

SQL> create table a(i number);
create table a(i number)
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kqlInvObj:user], [111], [], [], [],
[], [], [], [], [], [], []

Solution:

select * from sys.obj$where owner# in (111);  

delete from sys.obj$where owner# in (111);
commit;


SQL> create table a(i number);


Comments