The Oracle (tm) Users' Co-Operative FAQ

How do I identify which tablespaces are locally managed ?


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?

Back to index of questions


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


Back to top

Back to index of questions


Further reading: NA


Back to top

Back to index of questions