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.

Report message to a moderator

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: 26766
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

Report message to a moderator

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: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Log Miner.

Regards
Michel

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 03:52:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.