DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Tablespace Timestamp

  1. #1
    Join Date
    Jun 2001
    Posts
    243
    Hi,
    Is there a way to find out the Tablespaces' creation date? is there any data dictionary that I can look up?

  2. #2
    Join Date
    Jul 2002
    Location
    Washington DC
    Posts
    110
    Hi,

    Try this

    select a.file_name,a.tablespace_name,b.creation_time from dba_data_files a,v$datafile b
    where a.file_id=b.file# order by tablespace_name

    Manoj


  3. #3
    Join Date
    Feb 2001
    Posts
    27
    I want to add something with monoj's reply which is below:

    You'll get the tablespace's creation date indirectly. Monoj's query will basically tells the creation date of a datafile when one add it to a tablespace.

    Since during creation of a tablespace, one have to specify a datafile( which is the mandatory requirement), so the creation date of the first datafile of a given tablespace is the creation date of that tablespace too.

    Hope it helps.


    Thanks
    Babu

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