To Resolve This Error:
Solution 1: Try to rebuild Indexes and
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';
Create a Backup table same as this table.
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.