RE: Tablespace recovery - TSPITR??

Backup you test database,open it in mount state, restore the tablespace in
question, do not try to recover because you do not have archivelogs, and
open. Export the table from the test database and import it into the target
database.  This may fail along the way, and if it does let me know, but this
should do it.

HTH,
Ruth

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of steve noyle
Sent: Monday, October 18, 2004 4:27 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Tablespace recovery - TSPITR??


I have a table that I need to recover from an old
backup. I seem to recall reading somewhere that I can
just plug in the old datafile into my test database
and access the table that way. The table is the only
object in the datafile. Unfortunately I do not have
any archived logs available. What I have available is
a test database and an old backup file where the table
resides.

If that is not possible, what are my options?

test database - 9.2.0.3 on HPUX
the old backup file was originally also from a 9.2.0.3
database on HPUX.

thanks.

steve





--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Other related posts: