I have received errors and been unable to export two tables in my 8i database. 184.108.40.206.
The oracle errors shows the file# and block#s in the dump/trace file.
If try to exp either of these tables I get block errors consistent with what is being reported.
When I look up the objects associated with the bad blocks I also see the same two tables which cannot be exported due to bad data.
When I ran the dbms_repair utility (after setting up properly etc.) it returns a count of 0 corrupt blocks.
If I run dbv utilities on my database when offline I get a list of half dozen or so bad blocks all consistent with errors and objects which are inaccessible due to bad blocks.
When running ANALYZE TABLE I see the bad blocks but it won't populate the INVALID_ROWS table created from @F:\ORANT817\RDBMS\ADMIN\UTLVALID.SQL script. So it sees bad block but no data.
Output from dbv is interesting too...
DBVERIFY - Verification complete
Total Pages Examined : 102400
Total Pages Processed (Data) : 99438
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 482
Total Pages Empty : 2468
Total Pages Marked Corrupt : 12
Total Pages Influx : 4
Any ideas to recover destructive or non-destructive? I am out of options. (ps don't want to use tape)