If the tablespace is a genuine temporary tablespace (and I bet it is with
tempfiles not datafiles) then no. If you lose it just recreate it. no data
will be lost by definition. If on the other hand it is in a permanent
tablespace there may really be permanent data in there in which case t needs
backing up, until you have corrected the problem.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Nabil Courdy" <moab88_at_emirates.net.ae> wrote in message
news:ae1f8554.0204040100.41f4b8ec_at_posting.google.com...
> Do the datafiles for the TEMP table space have to be backed up in a hot
backup?
> Currently, my script is not picking up these data files. (8.1.7 on
Solaris)
>
> Nabil
> =====
Received on Thu Apr 04 2002 - 03:14:45 CST
