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 to [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 ***


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.



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