|
-
Steps :
1. Find out what time the table was dropped using logminer.
2. Restore database to the other location (clone) before the time of table dropped.
from RMAN
- do the clone steps
and finally
run {
set until time "TO_DATE('17-APR-2006:12:26:50','DD-MON-YYYY:hh24:mi:ss')";
restore database;
recover database;
}
alter database open resetlogs;
finally export the table and import it into the production database.
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
|