none of them will capture DML changes
you have two choices:
1) turn on auditing... this will tell you at a macro level what has
been touched, but won't necessarily tell you who did it or if it was
done by the execution of his app
2) add an update_dt and an updated_by column to all tables and create a
trigger which fires on insert/update/delete to fill the column of the
row with sysdate and the userid of the user. This is very detailed,
down to the row level but may also not give you whether or not the
change was made during the execution of his application
--- Mandal, Ashoke [EMAIL PROTECTED] wrote:
Hi,
One of my developer wants to know what are the tables or any other
objects being modified during the execution of his application.
dba_objects have following 3 date fields. But I am not sure if any of
these date fields will capture the last DML(update, insert or delete)
time.
CREATED
LAST_DDL_TIME
TIMESTAMP
Any idea?
Thanks in advance,
Ashoke
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandal, Ashoke
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).