Friday, August 10, 2012

ERROR at line 1: ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []

To Resolve This Error:
Solution 1: Try to rebuild Indexes and 
ANALYZE TABLE Table_Name VALIDATE STRUCTURE;

Solution 2:  Still You are getting the same Error...
Try this..   
BEGIN
            DBMS_REPAIR.SKIP_CORRUPT_BLOCKS
                 ( SCHEMA_NAME => 'SCOTT', OBJECT_NAME => 'DEPT',
                   OBJECT_TYPE => dbms_repair.table_object, 
                    FLAGS => dbms_repair.skip_flag);
 END;
/

Check this Query:
              SELECT OWNER, TABLE_NAME, SKIP_CORRUPT FROM DBA_TABLES WHERE OWNER = 'SCOTT'; 


OWNER TABLE_NAME SKIP_COR
SCOTT ACCOUNT DISABLED
SCOTT BONUS DISABLED
SCOTT DEPT ENABLED

 Create a Backup table same as this table.
  • Then take the backup into backup table and drop the original.
  • Rename backup to original.
  • If the table is very big use Bulk collect to take backup.
  • Run statistics for New Table.
  

 
 
  

No comments:

Post a Comment