And if you use the "AS" syntax, you can put it wherever you want. Looks like this: ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/tmp/control.sql'; You need 9i or higher for this candy. On 03/23/2004 03:41:10 PM, Mary Bahrami wrote: > Yup; if you backup the current controlfile to trace, you will see the create > statement for your current temp tablespace at the end of the .trc file. > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On > Behalf Of Chris Stephens > Sent: Tuesday, March 23, 2004 11:35 AM > To: 'oracle-l@xxxxxxxxxxxxx' > Subject: RE: recoving the temp tablespace > > > > CREATE > > TEMPORARY TABLESPACE "TEMP" TEMPFILE '/path/TEMP1.dbf' SIZE whatever > > EXTENT MANAGEMENT LOCAL UNIFORM SIZE whatever; > > > > -----Original Message----- > From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx] > Sent: Tuesday, March 23, 2004 12:54 PM > To: oracle-l@xxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx; > oracle-databases@xxxxxxxxxxxxxxx; oracle-rdbms@xxxxxxxxxxxxxxx > Subject: recoving the temp tablespace > > > > 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 -----------------------------------------------------------------