Re: Changing TEMP tablespace from type PERMANENT to type TEMPORARY

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 8 Feb 2001 06:26:37 +1100
Message-ID: <3a81a170$1@news.iprimus.com.au>

They are good for everything, data and indexes too.

With one proviso: because extent sized is pretty well fixed in a locally managed tablespace, there is now greater importance than ever of ensuring appropriate segments are stored in appropriate tablespaces. Otherwise, there are going to be large numbers of tables sitting there with (say) 1 Mb extents when they only have 40 rows in them.

Regards
HJR <raas.no_spam_at_interware.hu> wrote in message news:95rkn7$vj8$3_at_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 - 13:26:37 CST