Home » Tables » Dba_Tablespaces 18c

Dba_Tablespaces 18c

37 rows 6.

59 DBA_TABLESPACES DBA_TABLESPACES describes all tablespaces in the database.

Related View.

USER_TABLESPACES describes the tablespaces accessible to the current user.

This view does not display the PLUGGED_IN column.

Column Datatype NULL Description; TABLESPACE_NAME.


Name of the tablespace.

29 rows DBA_TABLESPACES describes all tablespaces in the database.

Related View.

#, Connected to: Oracle Database 18c Enterprise Edition Release 18.




0 – Production Master table “SYSTEM”.

“SYS_IMPORT_FULL_01” successfully loaded/unloaded Starting “SYSTEM”.

“SYS_IMPORT_FULL_01”: system/***** directory=test_dir dumpfile=remap.

dmp logfile=imp_remap.

log remap_tablespace=USERS:USERSDEMO Processing object type #, You can query the DBA_TABLESPACES view to list the names and default storage parameters.

Example 2: Listing the Data Files and Associated Tablespaces of a Database You can query the DBA_DATA_FILES view to list the names, sizes, and associated tablespaces of a database.

DBA_TABLESPACES , USER_TABLESPACES: Descriptions of all (or user accessible) tablespaces.

DBA_TABLESPACE_GROUPS: Displays the tablespace groups and the tablespaces that belong to them.

DBA_SEGMENTS, USER_SEGMENTS: Information about segments within all (or user accessible) tablespaces.


Use the CREATE TABLESPACE statement to create a tablespace, which is an allocation of space in the database that can contain schema objects.

A permanent tablespace contains persistent schema objects.

Objects in permanent tablespaces are stored in data files.

An undo tablespace is a type of permanent tablespace used by Oracle Database to manage undo data if you are running your.

Home Articles 12c Here.

Multitenant : Manage Tablespaces in a Container Database (CDB) and Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.

1) The multitenant option introduced in Oracle Database 12c allows a single container database (CDB) to host multiple separate pluggable databases (PDB).

Manage Tablespaces in a CDB: Management of tablespaces in a container database (CDB) is same as a non-CDB database.

Provided you are logged in as a privileged user and pointing to the root container, the usual commands are all available.

dba_tablespaces 18c