Re: Creation time of Temporary tablespace

Hardy wrote:
> Hello
>
> Thanks for the Reply Nirav,but it didn't worked out for me because
> there are not alert log files, maybe because sql_trace is set to
> false.One thing is sure this Temp tablespace is created much after the
> database creation.
>
> Does someone knows any other workaround to find creation time of the
> temporary tablespace?
>
> Thanks
> Hardeep

1. Do not top post.
2. Alert logs MUST exist: Have nothing to do with sql_trace. Look harder!

SELECT name, value
FROM v$parameter
WHERE name = 'background_dump_dest';

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)