Re: use logminer to recover dropped table
- From: sundar mahadevan <sundarmahadevan82@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Wed, 25 Jan 2012 15:55:55 -0500
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@xxxxxxxxxxxxx>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.
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
