Re: datafiles and tempfiles

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:uhpmfc8tbeckf1_at_corp.supernews.com...
>
> "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.
>

Last time I checked they were both files and should be backed up when doing in a cold backup. Unless you want to have to recreate the temp tablespaces manually that is. Received on Mon Jul 01 2002 - 15:17:44 CDT