Database Backup and Recovery (MOSC)

MOSC Banner

How to extract only 1 table from an full online backup?

edited Feb 19, 2012 7:23PM in Database Backup and Recovery (MOSC) 7 commentsAnswered
Hello,
one of our employee has mistakenly updated a master data table in our erp system. We have a full online backup done a day before via:
backup device type disk tag 'manuell database' database include current controlfile;
backup device type disk tag 'manuell archivelogs' archivelog all not backed up delete all input;
allocate channel for maintenance type disk;
delete noprompt obsolete device type disk;
release channel;

Is there a way to recover only one table in another temporäry tablespace or extract the data of one table as textfile?
We have to restore just specific rows of that table!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center