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 23:29:09 +0200
Message-Id: <6.0.1.1.0.20040323232841.444327b0@pop.xs4all.nl>


next try to reply within the thread.

At 11:41 PM 3/23/2004, you wrote:
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)

Mladen, I agree. Reality doesn't.

To my daily experience, especially when setting up DG environments, I ran into several sites with locally managed temporary tablespaces, even unde 9.2. From one site I've still access to I copied this from their databasecreation-script: (I removed the SID, so noone gets insulted ;-)

create tablespace temp
temporary

datafile            '/u04/oradata/sidwashere/temp01.dbf'
size                400M

extent management dictionary
default storage
(
initial             1M
next                400K
minextents          1
maxextents          1000
pctincrease         0

)

When I'm hired to help with a DG setup, most of the times the database is already there. And there are still lots of DBA's around that keep stuck to Oracle7 practices. The dutch are known to be scroogy (is that the word?). I like it, I can make a living out of fighting the problems caused in this way. Just look at my signature. As long as they don't listen to that, I'm in business (even without being an OCP, and despite more-or-less hating cats. I like cats, as long as they stay away at least a 100 yards.)

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===



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 - 18:57:53 CST

Original text of this message

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