Restore one single table for a full Oracle database backup

LeTay
LeTay used Ask the Experts™
on
Is it possible to restore one single table and nothing else from a full Oracle database backup ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
johnsoneSenior Oracle DBA

Commented:
I do not believe so.

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.
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Assuming a 'full backup' is a datafile backup and not an export, then I agree with johnsone.

If the 'error' that caused this need is recent you might be able to query the table using flashback query:
http://www.orafaq.com/node/50

Commented:
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.


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial