x

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.

more ▼

asked Dec 21, 2009 at 08:39 AM in Default

OraLearner gravatar image

OraLearner
1.3k 76 86 88

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.
Dec 21, 2009 at 11:21 AM HillbillyToad
Thank you for your suggestion. I explored more in extend to your post and got the answer as given by me.
Dec 22, 2009 at 01:15 PM OraLearner
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Dec 22, 2009 at 01:15 PM

OraLearner gravatar image

OraLearner
1.3k 76 86 88

(comments are locked)
10|1200 characters needed characters left
more ▼

answered Dec 21, 2009 at 12:04 PM

HillbillyToad gravatar image

HillbillyToad
1k 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x378
x84
x50

asked: Dec 21, 2009 at 08:39 AM

Seen: 1047 times

Last Updated: Dec 21, 2009 at 01:05 PM