ORA-600: internal error code, arguments: [kdsgrp1]
Hello,
An error 600 occurs often since one day. In the incident files, always:
row 0x04c36a96.3 continuation at: 0x04c36a96.3 file# 19 block# 223894 slot 3 not found (dscnt: 0)
The request : SELECT segment_type, owner, segment_name FROM dba_extents WHERE file_id = 19 AND 223894 BETWEEN block_id AND block_id+blocks-1;
--> A partitioned table (partition name found because the file_id is the one's of a datafile in a partitioned tablespace)
I didn't find clearly what to do with this type of error. Analyze the table? Rebuild indexes (i don't think so)? Create a new partition like the other ones, drop the old partition, rename the partition the partition ...