Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: temp datafiles not on restore tapes
"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?
-- 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 '.... RegardsReceived on Fri Jan 06 2006 - 16:13:01 CST
![]() |
![]() |