Re: Backing up TEMP tablespaces

In article <3c27754f$1_1_at_corp-goliath.newsgroups.com>, "Rhugga" says...
>
>
>It is necessary to backup temporary tabelspaces when doing a hot backup?
>(Oracle 8.1.7)
>

if they are TRUE temporary tablespaces:

create TEMPORARY TABLESPACE

with tempfiles (NOT datafiles), the answer is a resounding NO (it doesn't make sense to back them up)

If they are tablespaces that were created with DATAFILES (not tempfiles), then it is upto you. Backing them up makes a restore a tad easier, not having them in the backup makes you perform extra steps during a restore. If you know how to do the restore without them (and you should *practice* that a couple of dozen times), you may skip them as long as they are really just TEMP spaces....

>
>Thanks,
>CC
>
>
>______________________________________________________________________________
>Posted Via Binaries.net = SPEED+RETENTION+COMPLETION = http://www.binaries.net

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp