Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reading corrupted Datafiles offline

Re: Reading corrupted Datafiles offline

From: <jost_at_unitrade.com>
Date: Wed, 14 Sep 2005 13:54:16 +0200
Message-Id: <200509141354.16799.jost@unitrade.com>

Hello List,

i wish to thank you all for your helpful input.

After some good hints via this list i decided to do it the following way.

I recovered the database without the missing files. Some "alter Database datafile ' ' offline drop" did the job. Thx Juan ;-);-)

After that i wrote a small package wich generated the rowid's of the objects
we are interested in. Thx Lou ;-);-) Within a small shell script this rowid's
generated the SQL 's to read the data into ascii - files. So we were able to
put the data via sqlloader into a new database. Not a realy nice way, but it
did the job.

Thx again.

 Jörg

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 14 2005 - 06:57:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US