temp datafiles not on restore tapes

  • From: "J. Dex" <cemail_219@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 6 Jan 2006 13:36:26 -0500

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


--
//www.freelists.org/webpage/oracle-l


-- //www.freelists.org/webpage/oracle-l


Other related posts: