Backing up of Temp Tablespace is not reqd...

Just create a new temp tablespace wherever you restore it.

Regards,
Rahul Dutta


-----Original Message-----
From: Fathy Neveen
[mailto:oracledba-ezmlmshield-x66868081.[Email address protected]
Sent: Wednesday, June 22, 2005 6:00 PM
To: LazyDBA Discussion
Subject: temp tablespace

I tried to take hot backup of temporary table space
>> alter tablespace temp begin backup;
But it gives error; can I take a cold backup of temporary table space in
oracle 9i?

Regards
Neveen Elsayyad



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _
Disclaimer:
The Information contained in this transmission may be confidential
and legally privileged.
If you are not the intended recipient, please advise the sender and
delete
this transmission and all copies.
Any views or opinions expressed in this email are solely by the author
and not
necessarily those of PGESCo.
PGESCo is not responsible for any political, religious, racial or
partisan opinion
in any correspondence conducted by its domain users. Therefore, any such
opinion
expressed, whether explicitly or implicitly, in any said correspondence
is not to be interpreted as that of PGESCo.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page