RE: use logminer to recover dropped table
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: "cure@xxxxxxxxxxxxx" <cure@xxxxxxxxxxxxx>, "jwilton@xxxxxxxxxxxxx" <jwilton@xxxxxxxxxxxxx>, "sundarmahadevan82@xxxxxxxxx" <sundarmahadevan82@xxxxxxxxx>
- Date: Wed, 25 Jan 2012 21:12:46 +0000
Indeed.
http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables011.htm
-joe
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Paul Harrison
Sent: Wednesday, January 25, 2012 2:09 PM
To: jwilton@xxxxxxxxxxxxx; sundarmahadevan82@xxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: RE: use logminer to recover dropped table
Flashback table will work even when the flashback is not enable?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jeremiah Wilton
Sent: Wednesday, January 25, 2012 1:32 PM
To: sundarmahadevan82@xxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: use logminer to recover dropped table
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
--
//www.freelists.org/webpage/oracle-l
Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient, you
should not use, copy, disclose, distribute or take any action based on this
message. If you have received this message in error, please advise the sender
immediately by reply email and delete this message. Although ICAT Managers,
LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for
viruses, it does not guarantee that either are virus-free and accepts no
liability for any damage sustained as a result of viruses. Thank you.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
