Re: Recover a single table

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Mon, 30 Aug 1999 11:00:59 -0700
Message-ID: <37CAC6DA.A6DB19BB@wolfenet.com>

To do point in time recovery like this, he'll also need tablespaces containing any active rollback segments. --
Jeremiah Wilton
http://www.wolfenet.com/~jeremiah

Connor McDonald wrote:

> You can do the following - its a pain but possible...
>
> 1. restore system tablespace and datafile which contains the missing
> table.
>
> 2. recover into a NEW database (ie tweak the control file) - you get a
> lot of "file missing" info etc etc but the database can be recovered.
>
> 3. export from the new database the table you want
>
> 4. blow away the new database
>
> 5. import into your true database
Received on Mon Aug 30 1999 - 13:00:59 CDT