On Sun, 2004-06-13 at 02:00, Graeme Farmer wrote: > Terry, > > Based on the premise that some data is better than no data (and the > assumption that the indexes are in a non-corrupted tablespace), you could > take the affected datafile offline, open the database and dump the data that > is in the indexes into copies of the tables then dump the data to an export > dump file. It's not ideal (unless you have indexes that cover all columns) Interesting experiment Graeme. This goes on my (ever growing) list of things to try. Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------