Re: Convert TS from dictionary to locally managed

From: Howard J. Rogers <howardjr20002_at_yahoo.com.au>
Date: Fri, 11 Apr 2003 00:39:42 +1000
Message-ID: <xcfla.11354$1s1.177102@newsfeeds.bigpond.com>

"Evangelos Giannoulas" <gie_at_pbihag.ch> wrote in message news:1049970085.257241_at_rio.ch.pbihag.ch...
> Hi,
>
> Has anyone tried to convert dictionary managed ts into locally
> using the TABLESPACE_MIGRATE_TO_LOCAL procedure?
>

I wouldn't touch it with a barge-pole. It does a useless job, resulting in a strange hybrid of a beast: a locally managed tablespace with odd-sized extents which can fragment just like a dictionary-managed one.

Since one of the main advantages of LMTs is that they don't fragment, because they use uniform extent sizes, this is a serious failing.

It's all the more serious because there's no need ever to convert in the first place: just create a new LMT, and use the 'alter table X move' and 'alter index Y rebuild' commands to move your segments into the new tablespace. Voila: LMT with 'proper' fixed extent sizes.

Regards
HJR
> Experiences?
> Is it safe to do it on a production system?
>
> Thanks,
> Vangelis
>
>
Received on Thu Apr 10 2003 - 09:39:42 CDT