Oracle ORA-00600: internal error code, arguments: [ktssdrp1] [ktsircinfo_num1] Missing Rows In tables – Example 1

Posted by PDSERVICE on Nov 13, 2015 In

If you cannot recover data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help.

Oracle Missing Rows In tables – Example 1

Tab$ with no entries in Seg$ - Errors

SQL> connect test/test

Connected.

SQL> drop table EMP;

ERROR at line 1:

ORA-00600: internal error code, arguments: [ktssdrp1], [11], [10], [9], [], [],[], []

SQL> select * FROM EMP;

select * FROM EMP

ERROR at line 1:

ORA-00600: internal error code, arguments: [ktsircinfo_num1], [11], [10], [9]

ERROR:

ORA-600 [ktsircinfo_num1] [a] [b] [c] [d] [e]

DESCRIPTION:

This exception occurs when there are problems obtaining the row cache information correctly from sys.seg$

ARGUMENTS:

Arg [a] tablespace number

Arg [b] file number

Arg [c] block number