Re: data extraction from a dbf file

Bonnie

You can recover across a resetlogs, but if you don't have the datafiles from before then, I think you're right - you're screwed.

Pete

"D. O'Shea" wrote:

> Thanks for teh replies. Here is exactly what happened. A tablespace
> was dropped which utilized the dbf file in question. Then the database
> was opened with a resetlogs applied. Now, if I try to recover the
> dropped tablespace so i can access the dtaa in the dbf file, It
> complains saying "datafile xxx.dbf was from before thelas resetlogs",
> and it will not bring it online. I have tried recreating the databse
> using the backup controlfile to trace, and then running the script to
> recreate the database, but it still will not recognoze the old ,dbf
> file. It simply will not let me access it since the resetlogs was
> performed after the tablspace was dropped. Unfortunalety I do not have
> a backup of the other .dbf files (system, etc) from before the
> resetlogs so I do believe I am "screwed".
>
> On Wed, 30 Jun 1999 13:10:09 -0700, Pete Sharman
> <psharman_at_us.oracle.com> wrote:
>
> >Bonnie
> >
> >In what way is it "screwed" (very descriptive term that!)? Can you
> >start it up? If not, your only option is to check with Support. They
> >have some tools that may be of use.
> >
> >HTH.
> >
> >Pete
> >
> >boshea_at_ulsterp.com.com wrote:
> >
> >> I have a database that is screwed, but I do have an intact .dbf data
> >> file. My question is, is there any way using some tool, to extract
> >> data from a .dbf file so I can at least import the table data into a
> >> new database instance?
> >>
> >> Bonnie
> >
> >--
> >Regards
> >
> >Pete
> >

--
Regards

Pete

Received on Thu Jul 01 1999 - 13:29:26 CDT