Locally Managed versus Dictionary Managed

---

Naturally, you are migrating from dictionary managed tablespaces to locally managed tablespaces. This means that the setting value in the EXTENT_MANAGEMENT column of DBA_TABLESPACES will be set to LOCAL for the tablespaces in question after running the DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL package procedure (it would have been set to DICTIONARY before). If necessary, you could migrate the same tablespaces back and forth between dictionary managed and locally managed (DBMS_SPACE_ADMIN. TABLESPACE_MIGRATE_FROM_LOCAL). Oracle's future direction is to have all tablespaces locally managed, including the System tablespace. You can check the current settings of your tables by running the following sql statement:

 Select tablespace_name, extent_management, allocation_type From dba_tablespaces; 

You will see values in the Allocation_type column of USER for tablespaces that were migrated using the DBMS_SPACE_ADMIN package and either UNIFORM or SYSTEM for newly created locally managed tablespaces (depending on what parameter you set for the Extent Management parameter).

---