| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Checking when a table was last updated.
Message----- Original Message -----
From: Clinton Naude
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, February 19, 2003 5:53 AM
Subject: Checking when a table was last updated.
Hi.
What sytax can I used to see when a table or object was last updated/modified?
Thanks
Clint
Confidentiality Warning
The contents of this message and any attachments are intended solely for the addressee's use and may be legally privileged and/or confidential. If you are not the addressee indicated in this message, any retention, distribution, copying or use of this message is strictly prohibited. If you received this message in error, kindly notify the sender immediately by reply e-mail and then destroy the message and any copies thereof. The content and any views expressed therein are, unless otherwise stated, the views of the author and not those of the company or any of its management or directors.
Whilst all reasonable steps are taken to ensure the accuracy and integrity of information transmitted, the company does not accept responsibility for any corruption of the information or data or breach of confidentiality as a result of electronic submission.
When addressed to the Momentum Employee Benefits clients any opinion or advice contained in this e-mail is subject to the terms and conditions expressed in any applicable terms of business.
If you are looking for object definition changes, check last_ddl_time column in dba_objects.
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Igor Neyman
INET: ineyman_at_perceptron.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). Received on Wed Feb 19 2003 - 09:33:46 CST
 |
 |