question

OraLearner avatar image
OraLearner asked

Is there any way to export a dropped table?

I want to know whether there is any way to export a table which was dropped recently. Any idea on this would be appreciated.

oracletableplsql
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
Thank you for your suggestion. I explored more in extend to your post and got the answer as given by me.
0 Likes 0 ·
OraLearner avatar image
OraLearner answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HillbillyToad avatar image
HillbillyToad answered
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.