Re: use logminer to recover dropped table
Date: Wed, 25 Jan 2012 15:55:55 -0500
Message-ID: <CADmQEr7B6e4=tO4k8sP9yx41pRB9eGNUtgi50aD3te2fn5SxJw_at_mail.gmail.com>
You folks are awesome. I restored it with flashback tablename to before drop. I checked the recyclebin after i dropped it but did not realize that i was supposed to check dba_recyclebin rather was digging deep into logminer. Good learning. Thanks all. I just love this wonderful mailing list.
On Wed, Jan 25, 2012 at 2:31 PM, Jeremiah Wilton <jwilton_at_bluegecko.net>wrote:
> Hi,
>
> Recycle Bin should be enabled by default, unless you have explicitly
> disabled it. Have you tried using:
>
> flashback table <x> to before drop;
>
> If the table is still in the recycle bin, it should just "un-drop."
>
> Log Miner won't really help, since the actual rows were not deleted. The
> DDL changes may be there, but you're on your own trying to put Humpty
> Dumpty back together again that way. It is certainly a lot more convoluted
> than just un-dropping the table.
>
> --
> Jeremiah Wilton
> http://www.bluegecko.net
>
> On Jan 25, 2012, at 9:57 AM, sundar mahadevan wrote:
>
> > Good day. yesterday i dropped a table accidentally on staging database
> > (11gSE1 Rel 2 on SLES 10 on no archive log mode and no flash recovery
> > enabled) and we do not have any backups to recover.
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 25 2012 - 14:55:55 CST