Re: Recover a table from cold backup-noarchivelog

IIRC, you also need to restore the rollback/undo tablespace files. I know they 
are not needed for recovery, but I think that Oracle 
expects them. I think this is what killed our first attempt at recovery, many 
many moons ago. I don't think you need TEMP however.

GUPTA, DEEPENDER wrote:
> If we know the default tablespace of the table then can't we just restore
> the associated datafiles, system datafile, temp datafile and control files
> and then startup mount the database. 
> Then "offline drop" all other datafiles apart from the above mentioned files
> and then open the database and take the export of the table.
> 

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: