| Author's name: Allan W. Tham Author's Email: allanwtham@hotmail.com |
Date written: Nov 13 2001 Oracle version(s): 8.1.7.0.0 |
| How am I supposed to know which tablespace is locally managed or dictionary managed? | |
Select tablespace_name, extent_management, allocation_type from dba_tablespaces where extent_management like '%LOCAL%';
Note: Wxtent_management indicates either DICTIONARY or LOCAL; allocation_type will be UNIFORM or AUTO for locally managed. For dictionary managed, allocation_type will show USER.
In the special case of a dictionary managed tablespace that has been converted to locally managed, the extent management will be LOCAL, but the allocation_type will show USER.
Further reading: NA
Further reading: NA