Re: Creation time of Temporary tablespace

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Fri, 15 Jul 2005 17:13:46 +0200
Message-ID: <42d7d2ab$0$9226$ba620e4c@news.skynet.be>

"hardy444" <hardy_hardeep_at_yahoo.co.in> wrote in message news:1121428261.995468.46250_at_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
>

mmm ... the alert logfile maybe ? Normally in the $ORACLE_HOME/admin/bdump folder. Received on Fri Jul 15 2005 - 10:13:46 CDT