-
hi,
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
Junior member
-
First off,a couple ?s...are you in archive mode? what BU method are you using, e.g. RMAN, cold, hot?
Tim Hussar
-
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.
after that:
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.
enable constraints.
sonofsita
http://www.ordba.net
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|