RE: use logminer to recover dropped table
Date: Wed, 25 Jan 2012 15:09:18 -0600
Flashback table will work even when the flashback is not enable?
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeremiah Wilton
Sent: Wednesday, January 25, 2012 1:32 PM To: sundarmahadevan82_at_gmail.com
Subject: Re: use logminer to recover dropped table
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:Received on Wed Jan 25 2012 - 15:09:18 CST
> 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-l -- http://www.freelists.org/webpage/oracle-l