Re: migrating to locally managed tablespaces

Hi Frederic,

Oooops...I stand self-corrected : It is of course alternative a) and b) that require a full backup before proceeding.

• Kenneth

>Hi Frederic,
>
>There's more than one way to do that task, e.g. :
>
>a) The DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL() proc. converts
>a DMT to a LMT. Oracle provides full documentation on this. I know
>that there has, over time, been some dispute over this tool and it's
>efficiency and reliability. Try checking metalink on this.
>
>b) Create new LMT's on the DB and move the segments in the old DMT's
>to the new LMT's with :
>
> "Alter index indx_in_dmt rebuild tablespace NEW_IDX_LMT;"
> "Alter table table_in_dmt move tablespace NEW_TABLE_LMT;"
>etc.
>
>c) Create a new DB with LMT's, export from the old one and import to
>new one.
>
>Each of these methods has its advantages and disadvantages, regarding
>downtime, resource requirements etc.
>
>At least with a) and c), a full backup before proceeding is highly
>recommended.
>
>Good planning and extreme care is required in all 3 cases, but of
>course, even as a Junior DBA you know that :-) .Good Luck !
>
>- Kenneth Koenraadt
>
>
>
>
>
>
>
>
Received on Mon Jan 20 2003 - 00:25:27 CST