Home » RDBMS Server » Server Administration » Finding information about updated tables (10.2.0.3.0 on Unix)
Finding information about updated tables [message #393903] Tue, 24 March 2009 19:36 Go to next message
jcyp_71
Messages: 15
Registered: March 2009
Junior Member
Hello,

Is there a user/dba table or any other way(not a trigger) to find out if an application table has been updated and when it has been updated? In fact, not only updated but whatever dml that has been applied on it.

Thanks in advance.
Re: Finding information about updated tables [message #393904 is a reply to message #393903] Tue, 24 March 2009 19:42 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Is there a user/dba table or any other way(not a trigger) to find out if an application table has been updated and when it has been updated?

The application which does the DML could take responsibility for capturing changes before the DML is COMMIT(ed).


>In fact, not only updated but whatever dml that has been applied on it.

At least two possible solutions exist
AUDIT can report which tables are changed & when
Change Data Capture


Re: Finding information about updated tables [message #393940 is a reply to message #393903] Wed, 25 March 2009 01:57 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Log Miner.

Regards
Michel
Previous Topic: Warning: No logon on database at all with logon trigger - bug? (merged)
Next Topic: TNS listener could not resolve service name
Goto Forum:
  


Current Time: Thu Dec 08 00:10:49 CST 2016

Total time taken to generate the page: 0.09769 seconds