Creation time of Temporary tablespace

From: hardy444 <hardy_hardeep_at_yahoo.co.in>
Date: 15 Jul 2005 04:51:02 -0700
Message-ID: <1121428261.995468.46250@z14g2000cwz.googlegroups.com>

Hi all

I want to know when was the temporary tablespace in my database created.The database version is 8.1.7(running on tru unix) and there is only one Temporary tablespace having tempfiles.

I tried the query
select creation_time from v$tempfile;
but it gives a NULL value like...
CREATION_

Is there any other way i can find the creation time fo the tempfile or the tablespace(i bank upon the idea they were created at the same time.)

Thanks in Advance
Hardy Received on Fri Jul 15 2005 - 06:51:02 CDT