Re: LAST_DDL_TIME from ALL_OBJECTS

From: Asif Momen <asif_oracle_at_yahoo.com>
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 **************************

Antes de imprimir este mensaje, por favor, compruebe que es realmente necesario. Una tonelada de papel implica la tala de unos 15 �rboles y el consumo de 250.000 litros de agua. El Medio Ambiente es cuesti�n de TODOS.

• LOOK AFTER THE ENVIRONMENT! *******************

Before you print, please think about whether it's really necessary. One ton of paper means felling about 15 trees and consuming 250,000 litres of water. Looking after the environment is EVERYONE'S job.

• CL�USULA DE CONFIDENCIALIDAD *******************

Este correo electr�nico y/o los documentos que lo acompa�an pueden contener informaci�n confidencial y/o reservada dirigida exclusivamente al uso de los destinatarios. Si Usted no es destinatario (o ha recibido este correo electr�nico por error), no est� autorizado a copiar o distribuir esta comunicaci�n a ninguna otra persona. Le rogamos nos la devuelva y la elimine de su sistema.

• CONFIDENTIALITY NOTICE *****************************

This e-mail and/or the attached documents may contain confidential and/or sensitive information for the exclusive use of the addressees. If you are not the intended recipient (or have received this e-mail in error) you are not authorized to copy or distribute this message to any other person. Please return the message to the sender and destroy this e-mail.

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 **************************

Antes de imprimir este mensaje, por favor, compruebe que es realmente necesario. Una tonelada de papel implica la tala de unos 15 �rboles y el consumo de 250.000 litros de agua. El Medio Ambiente es cuesti�n de TODOS.

• LOOK AFTER THE ENVIRONMENT! *******************

Before you print, please think about whether it's really necessary. One ton of paper means felling about 15 trees and consuming 250,000 litres of water. Looking after the environment is EVERYONE'S job.

• CL�USULA DE CONFIDENCIALIDAD *******************

Este correo electr�nico y/o los documentos que lo acompa�an pueden contener informaci�n confidencial y/o reservada dirigida exclusivamente al uso de los destinatarios. Si Usted no es destinatario (o ha recibido este correo electr�nico por error), no est� autorizado a copiar o distribuir esta comunicaci�n a ninguna otra persona. Le rogamos nos la devuelva y la elimine de su sistema.

• CONFIDENTIALITY NOTICE *****************************

This e-mail and/or the attached documents may contain confidential and/or sensitive information for the exclusive use of the addressees. If you are not the intended recipient (or have received this e-mail in error) you are not authorized to copy or distribute this message to any other person. Please return the message to the sender and destroy this e-mail.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 02 2008 - 06:22:39 CDT