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: Ron Rogers <RROGERS_at_galottery.org>
Date: 2006-01-06 16:20:15
Message-id: s3be4470.055@smtp.galottery.org


J,
 On the source database...backup the controlfile to trace.  If you look at the controlfile created in the dump destination that was created with the \ "ALTER DATABASE BACKUP CONTROLFILE TO TRACE;" command you will see that the TEMP files \ are created independant of the other datafiles.

Ron

>>> "J. Dex" 01/06/06 10:06 AM >>>

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 




The information transmitted is intended solely for the individual or entity to which it is \ 
addressed and may contain confidential and/or privileged material. Any review, \ 
retransmission, dissemination or other use of or taking action in reliance upon this \ 
information by persons or entities other than the intended recipient is prohibited. If you \ 
have received this email in error please contact the sender and delete the material from \ 
any computer.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 06 2006 - 16:20:15 CST

Original text of this message

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