On 03/23/2004 01:05:14 PM, Carel-Jan Engel wrote: > Be sure your temporary tablespace is: > - temporary ;-) > - locally managed > - contains only temporary files Carel, if it's temporary and locally managed (the last time I created a dictionary managed temp tablespace was in 8.1.7 because a nasty bug in XML toolkit, which could bring down the instance) > > Then issue: alter tablespace <TS_NAME> add tempfile 'your filename here' > size <someGB> REUSE; > > This creates the temporary file for the existing temporary tablespace. Do > this for every tempfile in your temporary tablespace. > > Regards, Carel-Jan > > === > If you think education is expensive, try ignorance. (Derek Bok) > === > > At 08:53 PM 3/23/2004, you wrote: > >With 9i, we have implemented the temp tablespace. This tablespace does > >not get backed up. Shortly, we are going to move this database to a new > >server. We will > > > >- backup the database (hot backup) > >- shutdown the database > >- restore it to the new server. > >- copy the control file to the new server > >- copy the log files to the new server > >- start the database > >- do recovery so that it will apply the log files since the backup until > >the shutdown. > > > >Question is in regards to the temp tablespace. Since it was not backed > >up, how do we recreate it? > > > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------