How To Change A Dictionary Managed Tablespace To A Locally Managed Tablespace?

(Doc ID 735978.1)

Last updated on DECEMBER 12, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 12.2.0.1 [Release 10.2 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 28-Nov-2011***
*** Checked for relevance on 12-Apr-2016 ***


Goal

How to migrate Dictionary Managed Tablespace (DMT) to a Locally Managed Tablespace (LMT) using DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure.

Warning: It is highly recommended to test the steps in similar test environment to have an estimate of the time required for migration before implementing in Production.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms