Regarding TImestamp column in dba_objects
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Regarding TImestamp column in dba_objects

  1. #1
    Join Date
    Dec 2001
    Posts
    96

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331

    Re: Regarding TImestamp column in dba_objects

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width