Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table point-in-time recovery with only one instance / database
On Jun 8, 11:20 am, Steve Howard <stevedhow..._at_gmail.com> wrote:
> 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
But that's only available with 10g. Received on Thu Jun 07 2007 - 21:17:47 CDT
![]() |
![]() |