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: <jms.news_at_gmail.com>
Date: Fri, 08 Jun 2007 01:09:37 -0000
Message-ID: <1181264977.140563.324120@a26g2000pre.googlegroups.com>


On Jun 8, 11:02 am, Steve Howard <stevedhow..._at_gmail.com> wrote:
> On Jun 7, 7:48 pm, "jms.n..._at_gmail.com" <jms.n..._at_gmail.com> wrote:
>
>
>
> > I am doing a performance and regression testing of an application
> > ( irrelevant at this point ). What that I am trying to do is:
>
> > 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].
>
> > Instead of doing an export and import of all of the user's data
> > ( tables, indexes, etc... ), I was wondering if it would be possible
> > to do a tablespace point-in-time recovery instead as some of the table
> > are large, and doing an import will take several hours specially when
> > the indexes are built. The user has data and indexes stored only on a
> > few tablespaces.
>
> > However, after reading the docs for TSPITR via transportable
> > tablespaces, it is saying that you need 2 databases: 1) The primary
> > and 2) The auxiliary. But I don't have such luxury. Is there anyway to
> > do a TSPITR with just the one database ??
>
> What version?

9i - 9.2.0.7.0 EE Received on Thu Jun 07 2007 - 20:09:37 CDT

Original text of this message

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