I am Junior member. I have got problem of data block corruption error in one large table.
can anyone guide me that how to do the recovery?
Thanks in advance
First off,a couple ?s...are you in archive mode? what BU method are you using, e.g. RMAN, cold, hot?
Extracting good rows from the table is a huge process.
You must know various methods, like using ROWID (min / max) , PK etc.
The simple solution is:
Create a temp table by using CREATE TABLE aaa SELECT * from corrupted table order by PK DESC.
Then Use INSERT INTO aaa SELECT * from corrupted table order by PK ASC.
you may be helped by this:
run dbverify to fix that corruption..if it is at Oracle level that will take care of it.
create temp_x as select * from x
extract the index definitions on x or note on ehich columns you have indexes and what type. also constraints.
drop table x
rename temp_x as x and recreate the indexes.
Click Here to Expand Forum to Full Width