If you are creating your own hot backup, (like me), I like to include
the trace controlfile: alter database backup controlfile to trace as
'<file_name>';

Inside you will already have available stuff you can use like creating
the tempfiles for the temporary tablespaces, (the definitions of the
tablespaces will have already been restored from the system tablespace).

It is also just a handy thing to have with all your other files.

-----Original Message-----
From: Rahul Dutta
[mailto:oracledba-ezmlmshield-x20987659.[Email address protected]
Sent: Wednesday, June 22, 2005 8:31 AM
To: LazyDBA Discussion
Subject: RE: temp tablespace

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



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