Without a backup or an export, I don't think this is possible. Even if it is
development, backups are important if you want to be able to recover. If you
can load the data from a different source, say production, then that may be
fine for you.
- Onkar N Tiwary <onkarnath.tiwary_at_gmail.com> wrote:
> Hi,
> Today I had been asked one question : Scenario is : My DB is in noarchive
> log mode, no backup available, one of the datafile got corrupted say
> users01.dbf containing one schema TEST. Now can I recover the objects of the
> schema from that corrupted dbf file? If yes then how????
> Note : Partial/full data loss is acceptable as its a development db but all
> the objects are required!!!
>
> --
> Thanks & Regards,
> T. Onkar Nath
> OneAPPS Enterprise Technology Pvt. Ltd.
> to_onkar_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Nov 19 2005 - 08:36:20 CST
