To check if tablespace is dictionary managed or locally managed



select
tablespace_name, extent_management from dba_tablespaces
where
tablespace_name = <Tablespace_name> order by 1
Recent Posts