| Modification Time and Date [message #63629] |
Thu, 21 October 2004 07:53  |
Shain Miley
Messages: 6
Registered: July 2004
|
Junior Member |
|
|
Hi,
I am trying to write a command line script that will take the place of a GUI interface in order to make 'mass additions' to the database. Due to the closed source nature of the app I am not sure exactly which tables the GUI makes modifications to. What I am looking for is a way to determine which tables have been modified within the last n minutes. I do not necessarily need to know which rows have been changed....only which tables. My plan is to add a few entries with the GUI then try and see which tables have had updated in the last 5 minutes in order to help determine which tables I need to focus on. Does anyone know of a way to achieve this?
Thanks in advance.
Shain
|
|
|
|
|
|
| Re: Modification Time and Date [message #63631 is a reply to message #63629] |
Thu, 21 October 2004 08:11  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
I believe that audit may help.
You can try to setup table auditing options and then check table sys.aud$ to check time and date when table has been accessed.
I think that could help.
There are several options for auditing, i remember
something like BY ACCESS, so, any time table has been accessed will be tracked for auditing.
Best luck.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
