Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Table point-in-time recovery with only one instance / database

Re: Table point-in-time recovery with only one instance / database

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Fri, 08 Jun 2007 01:20:03 -0000
Message-ID: <1181265603.730347.118970@p47g2000hsd.googlegroups.com>


On Jun 7, 9:09 pm, "jms.n..._at_gmail.com" <jms.n..._at_gmail.com> wrote:
>
> > > 1) Export all of the user's data
> > > 2) Run the application
> > > 3) Drop all of the user's objects and import the user's data from step
> > > [1].
> > > 4) Run modified application
> > > 5) Compare run-time and performance between [2] and [4].
>
> > What version?
>
> 9i - 9.2.0.7.0 EE

If I am understanding what you want to do, you could try flashback table, provided you have enough undo space.

HTH, Steve Received on Thu Jun 07 2007 - 20:20:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US