RE: corrupt datafile

From: Jared Still <jkstill_at_cybcon.com>
Date: Mon, 14 Jun 2004 08:59:28 -0700
Message-Id: <1087228768.2097.209.camel@poirot>

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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jun 14 2004 - 10:46:52 CDT