Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: temp datafiles not on restore tapes

Re: temp datafiles not on restore tapes

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: 2006-01-06 19:36:31
Message-id: 20060106183631.GG16857@iris.uqtr.ca

"J. Dex" wrote: I am trying to stand up a database from a tape restore and rename it. \ The
restore did not include any of the temp datafiles but I think I know what the temp tablespace had been called. How should this be addressed? In the create controlfile script, should I have an alter tablespace petemp add datafile.... or will I have to create a new temp tablespace? Can the temp tablespace be created after the database is opened?



Is your PC infected? Get a FREE online computer virus scan from McAfee« Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
http://www.freelists.org/webpage/oracle-l



Tempfiles are not backed up as there is no need to back them up.
   
  They have to be created after the restore, using
  alter tablespace "temp_tbsp_name" add tempfile '....
   
  Regards
Received on Fri Jan 06 2006 - 19:36:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US