|
I want to know whether there is any way to export a table which was dropped recently. Any idea on this would be appreciated.
(comments are locked)
|
|
export can be done for objects as of time using the flashback_time or flashback_scn export parameters. Data Definition Language statements that alter the structure of a table, such as drop/modify column, move table, drop partition, truncate table/partition, and so on, invalidate the old undo data for the table. It is not possible to retrieve a snapshot of data from a point earlier than the time such DDLs were executed. To export a dropped table you will need first to execute flashback drop on it.
(comments are locked)
|
Your answer
You want to backup a table after you dropped it? Do you have flashback enabled? Maybe you can rewind the database to where before your dropped it. Otherwise, you get to try our your backup and recovery protocols.
Thank you for your suggestion. I explored more in extend to your post and got the answer as given by me.