RE: flashback query vs. log miner
- From: Kirtikumar Deshpande <kedeshpande@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 24 Jul 2004 07:49:49 -0700 (PDT)
Paula,
One must use LogMiner if one needs to access data that is more than 5 days old
(instance
uptime wise). FBQ does not help you. Of course, this changes with Oracle 10g (
and what
doesn't? ;).
Also, with 9i rel 2 SQL enhancement (the AS OF clause) it is very easy to use
FBQ to
access past data (if it is still available in the undo segments). Accessing the
same
information via LogMiner is a bit more involved process. With proper
privileges, you can
let your developers use FBQ, but I doubt if DBAs will allow Developers to play
with
LogMiner.
So, I would not use one versus the other all the time, but may be required to
use both,
depending on the requirement.
Regards,
- Kirti
--- Paula_Stankus@xxxxxxxxxxxxxxx wrote:
> Guys,
>
> I know you can reconstruct data in a table (given your undo segments in =
> your undo tablespace is not overwritten)
> with flashback query. However, you should be able to do the same using =
> log_minor.
>
>
> So flashback is easier to work but probably couldn't restore as much as =
> you could using log_minor. =20
>
> Why would you use one versus the other?
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
