Home » SQL & PL/SQL » SQL & PL/SQL » Table changes capture through triggers
Table changes capture through triggers [message #246206] Wed, 20 June 2007 05:16 Go to next message
sarans
Messages: 30
Registered: November 2006
Location: UK
Member
I would like to know the best way to extract the information on a table column change through trigger, I don't want to do the :new :old comparison....

All I am interested is to monitor only the value changed table column.... and it should be dynamic and less maintenance....

Please let me know...
Re: Table changes capture through triggers [message #246212 is a reply to message #246206] Wed, 20 June 2007 05:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I would like to know the best way to extract the information on a table column change through trigger, I don't want to do the :new :old comparison....

How would you know the values without using where they are that is in :OLD and :NEW?

Regards
Michel

[Updated on: Wed, 20 June 2007 06:29]

Report message to a moderator

Re: Table changes capture through triggers [message #246228 is a reply to message #246212] Wed, 20 June 2007 06:14 Go to previous messageGo to next message
sarans
Messages: 30
Registered: November 2006
Location: UK
Member
Michel

Perfect question, see below my requirement:-

1. Check for all the tables, what are the column values changed.
2. For those changed column tables, extract the data and process.

Note: I have requested from the Trigger, if there is any other better way to achieve the above, please let me know...
Re: Table changes capture through triggers [message #246231 is a reply to message #246228] Wed, 20 June 2007 06:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you want to do it on the fly, no.
You can have a look at Fine-Grained Auditing (which is based on internal triggers).

Afterwards, you can mine your logs using Log Miner.

Regards
Michel

Re: Table changes capture through triggers [message #246233 is a reply to message #246231] Wed, 20 June 2007 06:41 Go to previous message
sarans
Messages: 30
Registered: November 2006
Location: UK
Member
Cheers, Michel...

I will have a look....
Previous Topic: Replace No Rows Returned with Zeros
Next Topic: How to change the structure of a table permanently
Goto Forum:
  


Current Time: Wed Dec 07 09:09:05 CST 2016

Total time taken to generate the page: 0.09079 seconds