Regarding TImestamp column in dba_objects
Hi all,
The view DBA_OBJECTS contains the columns CREATED and
LAST_DDL_TIME.
The column descriptions:
CREATED - Timestamp for the creation of the object
LAST_DDL_TIME - Timestamp for the last modification of the object
resulting from a DDL command (including grants and
revokes)
Is this true that "TIMESTAMP" column contains DDL modifications such as CREATE or ALTER but excludes grants and revokes.
waiting for inputs.
Re: Regarding TImestamp column in dba_objects
Quote:
Originally posted by aj_usa
Hi all,
The view DBA_OBJECTS contains the columns CREATED and
LAST_DDL_TIME.
The column descriptions:
CREATED - Timestamp for the creation of the object
LAST_DDL_TIME - Timestamp for the last modification of the object
resulting from a DDL command (including grants and
revokes)
Is this true that "TIMESTAMP" column contains DDL modifications such as CREATE or ALTER but excludes grants and revokes.
waiting for inputs.
waiting for you to read the documentation and even *gasp* try it out for yourself