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: recoving the temp tablespace

Re: recoving the temp tablespace

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Tue, 23 Mar 2004 20:05:14 +0200
Message-Id: <6.0.1.1.0.20040323200133.443f5440@pop.xs4all.nl>


Be sure your temporary tablespace is:

- temporary ;-)
- locally managed
- contains only temporary files

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_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Mar 23 2004 - 15:46:38 CST

Original text of this message

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