|
-
Hi,
You want to perform a user-managed incomplete recovery.
This type of recovery needs all data files to be restored.
You cannot restore only the tablespace where the table resides.
Simply restore all datafiles.
mount the database.
recover the database to a point-in-time using UNTIL TIME.
open the database using RESETLOGS.
If you are using a different controlfile, simply mount the database, rename all the datafiles and redo log files to the correctly restored name and location.
ALTER DATABASE DATAFILE 3 RENAME TO 'new_file_name';
create new redo log files and delete old ones.
Once the database is open, you can export the table.
Cheers,
R.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|