Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> datafiles and tempfiles
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
Received on Fri Jun 28 2002 - 14:26:16 CDT