LeTay
asked on
Restore one single table for a full Oracle database backup
Is it possible to restore one single table and nothing else from a full Oracle database backup ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, use TSPITR export table from that temporary database and import it on your main database
"Is it possible to restore one single table and nothing else from a full Oracle database backup ?"
Did you dropped it and want to restore?
Then use
Sql>Flashback Table table_name to before Drop;
You can also use "Flashback Table" feature
I don't think Flashback Query/Table can be useful here because Undo may be overwritten by the time you are doing Searching and R&D.
"Is it possible to restore one single table and nothing else from a full Oracle database backup ?"
Did you dropped it and want to restore?
Then use
Sql>Flashback Table table_name to before Drop;
You can also use "Flashback Table" feature
I don't think Flashback Query/Table can be useful here because Undo may be overwritten by the time you are doing Searching and R&D.
On a different server, you could restore just the SYSTEM, SYSAUX and the tablespace that contains the table. From there you should be able to export out the table in question and import it where you need it.