RE: flashback query vs. log miner

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Fri, 23 Jul 2004 17:32:20 -0400
Message-ID: <80D4A99A2715674EB2D256DAD89219F6044E8AD4@dohsmail02.doh.ad.state.fl.us>

Thanks for the input Mladen to my stupid question.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mladen Gogala Sent: Friday, July 23, 2004 5:27 PM
To: oracle-l_at_freelists.org
Subject: Re: flashback query vs. log miner

On 07/23/2004 05:24:34 PM, Paula_Stankus_at_doh.state.fl.us wrote:
> Guys,

>=20
> I know you can reconstruct data in a table (given your undo segments =
in =3D
> your undo tablespace is not overwritten)
> with flashback query. However, you should be able to do the same =
using =3D
> log_minor.

Of course, if the table is dropped, then restoring from recycle bin may = be an option.

--=20
Mladen Gogala
Oracle DBA

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 5376441) is spam:
Spam:        =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D5376441&m=3Dd529a=
3c4f77d
Not spam:    =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D5376441&m=3Dd529a=
3c4f77d
Forget vote: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D5376441&m=3Dd529a=
3c4f77d
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 23 2004 - 16:28:55 CDT