Home » SQL & PL/SQL » SQL & PL/SQL » List of modified tables Modifications
List of modified tables Modifications [message #239275] Mon, 21 May 2007 21:35 Go to next message
ksrijith
Messages: 4
Registered: May 2007
Junior Member
Hi,

Is there some way i could find the tables where data has been added to during the given time period in a particular schema.

Regards,
SRijith
Re: List of modified tables Modifications [message #239277 is a reply to message #239275] Mon, 21 May 2007 21:41 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
you wanna find dml on tables??who did and when??
Re: List of modified tables Modifications [message #239284 is a reply to message #239277] Mon, 21 May 2007 22:35 Go to previous messageGo to next message
ksrijith
Messages: 4
Registered: May 2007
Junior Member
Yes I want to find the dml on all the tables... kind of get the time stamps on all the modifications done. Is it possible.
Re: List of modified tables Modifications [message #239285 is a reply to message #239275] Mon, 21 May 2007 22:40 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Is it possible.
It can be if you use LOGMINER.
Re: List of modified tables Modifications [message #239286 is a reply to message #239285] Mon, 21 May 2007 22:45 Go to previous messageGo to next message
ksrijith
Messages: 4
Registered: May 2007
Junior Member
hmmm.. thanks for you help
Re: List of modified tables Modifications [message #239366 is a reply to message #239286] Tue, 22 May 2007 03:01 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or you could switch on Auditing - that would certainly let you know which tables had been modified.

Other than that, you'll have to add a last_modified column to each table and populate it with a trigger.
Re: List of modified tables Modifications [message #239537 is a reply to message #239366] Tue, 22 May 2007 10:52 Go to previous message
ksrijith
Messages: 4
Registered: May 2007
Junior Member
hmmm... the modified flag is needed in a few tables but will be a waste for all of them... thanks for your inputs....

i'll try with the auditing set as on..
Previous Topic: Create view - execute a function where it inserts a record
Next Topic: ORA-30926: unable to get a stable set of rows in the source tables
Goto Forum:
  


Current Time: Sun Dec 11 04:33:58 CST 2016

Total time taken to generate the page: 0.16281 seconds