Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: monitor data change

Re: monitor data change

From: Yong Huang <yong321_at_yahoo.com>
Date: 29 Oct 2003 10:58:26 -0800
Message-ID: <b3cb12d6.0310291058.3b2b44b5@posting.google.com>


Or try the Change Data Capture feature in 9i. It's discussed in Data Warehousing Guide and the relevant packages are DBMS_LOGMNR_CDC_PUBLISH and DBMS_LOGMNR_CDC_SUBSCRIBE.

Yong Huang

"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message news:<vpv9ugh4e5ko54_at_corp.supernews.com>...
> Assuming you are using 8i and above, one thing you can try is Logminer to
> scan the redo/archive logs. Refer to the documentation.
>
> Best of luck.
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
> Author of: 'So You Want to be an Oracle DBA?'
>
> "Pan Tao" <aa_at_aaa.aaa> wrote in message news:bno1bn$9hf$1_at_mail.cn99.com...
> > dear all,
> > I need to find out what data is changed in the database
> > after I do some operation by an application. May I read
> > it through the redo log? Is there some tool ? I need to
> > recover some data from backup in a hurry. Thanks for any
> > help!
Received on Wed Oct 29 2003 - 12:58:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US