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_at_freelists.org
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
-----------------------------------------------------------------
Received on Tue Aug 31 2004 - 10:23:39 CDT
