RE: How can I check the time when any table is updated under a sc
Ops, I misread the statement: during the execution of HIS application. WOW... I would not let that developer to mess with dba tables... -Original Message- Sent: Tuesday, July 23, 2002 2:34 PM To: Multiple recipients of list ORACLE-L It is common situation. He/she is probably a GUI developer. Most front end developers are not too familiar with dba tables. Mandal, you can do run this query next time you have a similar queston: 1 select column_name, comments 2 from dba_col_comments 3 where table_name='DBA_OBJECTS' 4* AND COLUMN_NAME IN ('TIMESTAMP','LAST_DDL_TIME','CREATED') SQL> / COLUMN_NAME COMMENTS --- --- CREATED Timestamp for the creation of the object LAST_DDL_TIME Timestamp for the last DDL change (including GRANT and REVOKE) to the object TIMESTAMP Timestamp for the specification of the object Look for more help on TIMESTAMP column, if it is not what you are looking for and there are only a few tables you need information about, may be creating trigger would help. SQL> -Original Message- Sent: Tuesday, July 23, 2002 1:59 PM To: Multiple recipients of list ORACLE-L I am surprised that the developer doesn't know the code s/he wrote/maintains. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! --- "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: Lyuda Hoska 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyuda Hoska 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).
RE: How can I check the time when any table is updated under a sc
It is common situation. He/she is probably a GUI developer. Most front end developers are not too familiar with dba tables. Mandal, you can do run this query next time you have a similar queston: 1 select column_name, comments 2 from dba_col_comments 3 where table_name='DBA_OBJECTS' 4* AND COLUMN_NAME IN ('TIMESTAMP','LAST_DDL_TIME','CREATED') SQL> / COLUMN_NAME COMMENTS --- --- CREATED Timestamp for the creation of the object LAST_DDL_TIME Timestamp for the last DDL change (including GRANT and REVOKE) to the object TIMESTAMP Timestamp for the specification of the object Look for more help on TIMESTAMP column, if it is not what you are looking for and there are only a few tables you need information about, may be creating trigger would help. SQL> -Original Message- Sent: Tuesday, July 23, 2002 1:59 PM To: Multiple recipients of list ORACLE-L I am surprised that the developer doesn't know the code s/he wrote/maintains. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! --- "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: Lyuda Hoska 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).
Re: How can I check the time when any table is updated under a
Ashoke, Any programer worth their salt should know what tables or objects are modified by their applications. They documented and wrote it and should know what happens when an "update, delete, insert, etc" happens to the data. If they do not know what happens, How did they write the application?. If it is an inherited application and the documentation is not available, that is a different story. Then you will have to use auditing or the "trigger to table" method. I know that I sound harsh in my statements but in the old school that's how we had to work, documentation, test, documentation I have found in today's programming world that to many times it is easier to cut and paste code to get the project running and not even do the documentation. PS( I retired from an ISO9001/2 company) ROR mª¿ªm >>> [EMAIL PROTECTED] 07/23/02 02:33PM >>> 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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).
RE: How can I check the time when any table is updated under a sc
I am surprised that the developer doesn't know the code s/he wrote/maintains. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! --- "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 *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: How can I check the time when any table is updated under a schema?
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).
How can I check the time when any table is updated under a schema?
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).