Creating Dictionary Managed Tablespaces

If the database is created using DBCA then we cannot create the Dictionary Managed Tablespace, we can create the Dictionary Managed Tablespace only when the database is created manually.

 

SQL> create tablespace venu

                datafile '/u02/app/oracle/ssss/venu01.dbf'

                size=2m

                extent management dictionary;

Note : By default, segment management is manual for Dictionary Managed Tablespaces and auto for Locally Managed Tablespaces. We can alter them if we need.