Re: Convert TS from dictionary to locally managed

From: D.Y. <dyou98_at_aol.com>
Date: 10 Apr 2003 11:37:35 -0700
Message-ID: <f369a0eb.0304101037.63e43cbf@posting.google.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?
>

All that's going to do is move the extent map from the system catalog to the tablespace itself. Space allocation will still be handled as if it were a dictionary managed tablespace.

> Experiences?
> Is it safe to do it on a production system?
>
> Thanks,
> Vangelis
Received on Thu Apr 10 2003 - 13:37:35 CDT