Re: datafiles and tempfiles

"Chuck" <chuckh_at_softhome.net> wrote in message news:afid8p$en847$1_at_ID-85580.news.dfncis.de...
> Is there a view already defined that lists both tempfiles and datafiles?
> Something similar to
>
> select * from dba_data_files
> union all
> select * from dba_temp_files
>
>
>

There is not. They are two different things, aren't they.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address