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: Mladen Gogala <mladen_at_wangtrading.com>
Date: Tue, 23 Mar 2004 16:41:02 -0500
Message-ID: <20040323214102.GA3401@mladen.wangtrading.com>


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_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 - 16:42:31 CST

Original text of this message

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