Date and time of creation of an object
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Date and time of creation of an object

  1. #1
    Join Date
    Sep 2001
    Location
    Chennai, India
    Posts
    4
    Is it possible to find out the time stamp of the creation of an object in the database, say a table, using an SQL query. I know, using the log miner we could do it by extracting information from the archived logs. My question is, whether it is possible to find out the date and time using an SQL query.
    Thank you
    Anil

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    select created
    from user_objects
    where object_type = 'TABLE'
    and object_name = '...'

  3. #3
    Join Date
    Sep 2001
    Location
    Chennai, India
    Posts
    4
    Thank you Pipo.
    Anil

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