We opened an SR with Oracle and they said pretty much the same thing for the workaround; here is what they said about it:
ODM Action Plan Oracle Support
=== ODM Action Plan ===
In order to recreate the table you need to disable the DB_BLOCK_CHECKINg because in other case, it will fail with the ORA-600 error. We are removing 1 check layer in order to be able to recreate the table. We know there is a block corruption, but we know as well it is not affected any data on the table, so we can do it safely.
Process should be:
1.-Disable DB_BLOCK_CHECKING
2.-Recreate the table
3.-Re-enable DB_BLOCK_CHECKING
On the other hand, the steps you can follow in order to fix the corruption are
DROP TABLE .. PURGE;
or
ALTER TABLE .. MOVE ..;
or
Create table as select(CTAS)
or
export/import,etc
You don't need to follow all steps but only one.
Since we have been using the CTAS workaround we have no longer been receiving the error. Here are the steps we are using now for this object:
Drop table tabone;
CTAS tmp_tabone;
Rename tmp_tabone to tabone;
Here is a nice little piece of code if you just want to find out what object is corrupt (replace the file and blockid):
select tablespace_name, segment_type, owner, segment_name
from dba_extents
where file_id =
and
No comments:
Post a Comment