It is pretty easy to restore and recover a single table to an arbitrary point in time from a physical backup. I don't think Oracle needs to provide an extra feature.
You restore a small subset of the database (system, rollbacks and the tablespace with the table in it), offline drop the datafiles you didn't restore, and roll the "mini-clone" forward to the point in time you want. Export/import the table from the "mini-clone" into the original database via named pipes. Query flashback won't work past a certain timeframe, and it won't work on tables that have been mangled by DDL (drop/truncate). And you have to use server-managed undo to use query flashback. Personally, there are a lot of queries the developers here have come up with that I have flashbacks of anyway, usually around 3 or 4 in the morning. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 28 May 2002, Rachel Carmichael wrote: > isn't that supposed to be flashback query? :) > > --- Gene Sais <[EMAIL PROTECTED]> wrote: > > maybe 10i will allow table pt in time recovery :) > > > > >>> [EMAIL PROTECTED] 05/25/02 05:53PM >>> > > you mean the export? it's a lot easier to recover a single table from > > an export and let everyone else keep working. AFAIK, Oracle still > > doesn't do table-level recovery, the lowest granularity is > > tablespace. > > > > Also, exports are good at letting you clone users and application > > schemas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
