Re: datafiles and tempfiles

Chuck wrote:

> "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.

No I have ever known backs up the temp tablespace. Do you back up log files too?

Daniel Morgan Received on Mon Jul 01 2002 - 15:20:07 CDT