Q
Manage Learn to apply best practices and optimize your operations.

Query for locally managed vs. dictionary-managed tablespace

What is the query to find out if the tablespace is locally managed or dictionary-managed?

What is the query to find out if the tablespace is locally managed or dictionary-managed?
Query the EXTENT_MANAGEMENT column of the DBA_TABLESPACES view. If the tablespace shows LOCAL in this column, then the tablespace is a locally managed tablespace. If the tablespace shows DICTIONARY, then it is a dictionary-managed tablespace.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close