Re: LAST_DDL_TIME from ALL_OBJECTS
Date: Wed, 2 Jul 2008 04:22:39 -0700 (PDT)
Message-ID: <259697.98175.qm@web56615.mail.re3.yahoo.com>
Hi Clark,
>Which DD view can I interrogate
to find the the time that the column was added to the
> table.
Unless you have enabled database auditing, you cannot view this information.
Regards
Asif Momen
http://momendba.blogspot.com
- On Tue, 7/1/08, paul.clark_at_externos.aseval.com <paul.clark_at_externos.aseval.com> wrote: From: paul.clark_at_externos.aseval.com <paul.clark_at_externos.aseval.com> Subject: LAST_DDL_TIME from ALL_OBJECTS To: oracle-l_at_freelists.org Date: Tuesday, July 1, 2008, 11:13 PM
I have been attempting to find the modification dates of varios objects by interrogating ALL_OBJECTS.LAST_DDL_TIME. However, I have noted that granting object privileges causes the last DDL time to be changed (even though granting an object priv is not actually DDL).
Example
15:00 HOURS: �
SQL> ALTER TABLE schema_1.table_1
ADD col_1 VARCHAR2(100);
15:15 HOURS:
SQL> GRANT SELECT, INSERT, UPDATE,
DELETE ON schema_1.table_1 TO schema_2;
15:30 HOURS: SQL> select object_name, TO_CHAR(LAST_DDL_TIME, 'YYYYMMDD HH24:MI:SS') last_ddl
� � � � �
�from all_objects
� � � � �
�where owner = 'SCHEMA_1'
� � � � �
�and object_name = 'TABLE_1';
OBJECT_NAME � � � �
� � � � � �LAST_DDL
- -----------------
TABLE_1 � � � �
� � � � � � � �20080701 15:15:00
<- NOTE, 15:15, the time of the Obj Priv grant, not 15:00 when
the � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � table was modified by adding a column
My question is: Which DD view can I interrogate to find the the time that the column was added to the table.
Thank you
P Clark
Paul Clark
Tel: (+34)
Fax: (+34)
paul.clark_at_externos.aseval.com
ATENCI�N: Esta cuenta de correo electr�nico ha sido modificada. Rogamos que lo tengan en cuenta y actualicen su lista de contactos de correo.
- MENSAJE MEDIOAMBIENTAL **************************
- LOOK AFTER THE ENVIRONMENT! *******************
- CL�USULA DE CONFIDENCIALIDAD *******************
- CONFIDENTIALITY NOTICE *****************************
Paul Clark
Tel: (+34)
Fax: (+34)
paul.clark_at_externos.aseval.com
ATENCI�N: Esta cuenta de correo electr�nico ha sido modificada. Rogamos que lo tengan en cuenta y actualicen su lista de contactos de correo.
- MENSAJE MEDIOAMBIENTAL **************************
- LOOK AFTER THE ENVIRONMENT! *******************
- CL�USULA DE CONFIDENCIALIDAD *******************
- CONFIDENTIALITY NOTICE *****************************
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 02 2008 - 06:22:39 CDT