Re: schema recovery

On 19/11/05, 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!!!
>

Have you tried an export with rows=n? That should only need to hit the data dictionary. You could then use it to import into another db or use a tool like ddlwizard to extract the ddl.

You might need to offline the datafile first.

This isn't something I've ever tried but I'm not aware of any reason it shouldn't work on priciple. The practice might be a little different.

That doesn't work but a describe does in SQL*Plus then it's possible to write a script to extract the DDL.

Stephen

--
It's better to ask a silly question than to make a silly assumption.

http://stephensorablog.blogspot.com/
--
http://www.freelists.org/webpage/oracle-l