RE: flashback query vs. log miner

From: Kirtikumar Deshpande <kedeshpande_at_yahoo.com>
Date: Sat, 24 Jul 2004 07:49:49 -0700 (PDT)
Message-ID: <20040724144949.160.qmail@web50107.mail.yahoo.com>

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_at_doh.state.fl.us 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_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 Sat Jul 24 2004 - 09:46:21 CDT