As I’ve got asked during the workshop in Warsaw how to migrate Dictionary Managed to Locally Managed tablespaces here’s some additional information and an example.
To find out if a tablespace is dictionary or locally managed you’d use this query:
TABLESPACE_NAME, EXTENT_MANAGEMENT from DBA_TABLESPACES;
The procedure to migrate to locally managed tablespace is:
And the whole migration procedure would look like this:
… Continue reading...
— do this for all tablespaces except SYSTEM, TEMP and SYSAUX
— necessary if there’s no “real” temp tablespace definded yet – see Note:160426.1