Re: datafiles and tempfiles

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Sat, 29 Jun 2002 09:04:43 +1000
Message-ID: <afiq44$ul$1@lust.ihug.co.nz>

Nope. Oracle doesn't want them to appear in the one view, because a lot of people's backup scripts select from v$datafile (or dba_data_files) to determine what needs backing up. Since tempfiles can't be recovered, you can't put them into hot backup mode. So including them in those views would throw errors in all those backup scripts.

Nothing to stop you creating your own view, of course.

Regards
HJR "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
>
>
>
Received on Fri Jun 28 2002 - 18:04:43 CDT