Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Table point-in-time recovery with only one instance / database
I am doing a performance and regression testing of an application
( irrelevant at this point ). What that I am trying to do is:
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 ?? Received on Thu Jun 07 2007 - 18:48:45 CDT
![]() |
![]() |