How do I identify which tablespaces are locally managed ?

The Oracle (tm) Users' Co-Operative FAQ

How do I identify which tablespaces are locally 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