Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Changing TEMP tablespace from type PERMANENT to type TEMPORARY

Re: Changing TEMP tablespace from type PERMANENT to type TEMPORARY

From: <raas.no_spam_at_interware.hu>
Date: 7 Feb 2001 14:05:27 GMT
Message-ID: <95rkn7$vj8$3@proxy.interware.hu>

Hi,

> permanent tablespace. And if you have 8i, no-one in their right minds would
> do anything other than have locally managed tablespace for the temporary
> tablespace (makes iniital extent allocation even faster).

would it be that after 8i, we should be using locally managed tablespaces for data/indices too?..

[yes I have read things and understood why they are GOOD. but perhaps you know of disadvantages that I do not.]

regards
r. Received on Wed Feb 07 2001 - 08:05:27 CST

Original text of this message

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