Data Dictionary Tablespace and Data File Information

Tablespace information can be found in the data dictionary in the views that you can find in Table 10.1. Table 10.1 is a list of data dictionary views along with a brief description of the information that can be found through those views.

Table 10.1. Data Dictionary Views of Tablespace Information

View	Description
V$TABLESPACE	Provides the name and number of tablespaces.
DBA_TABLESPACES	Provides descriptions of all tablespaces.
USER_TABLESPACES	Provides descriptions of all the given user's accessible tablespaces.
DBA_SEGMENTS	Provides information about segments associated with all tablespaces.
USER_SEGMENTS	Provides information about segments owned by the given user's accessible tablespaces.
DBA_EXTENTS	Provides information about data extents associated with all tablespaces.
USER_EXTENTS	Provides information about data extents associated with all tablespaces owned by a given user.
DBA_FREE_SPACE	Provides information about free extents associated with all tablespaces.
USER_FREE_SPACE	Provides information about free extents associated with all the given user's accessible tablespaces.
V$DATAFILE	Provides information about all data files, including the tablespace number of owning tablespace. This can be connected to V$TABLESPACE to get the tablespace data file correlation.
V$TEMPFILE	Provides information about all tempfiles, including tablespace number of owning tablespace.
DBA_DATA_FILES	Provides information on data files belonging to tablespaces.
DBA_TEMP_FILES	Provides information on tempfiles associated with temporary tablespaces.
DBA_USERS	Provides information about the default tablespace and temporary tablespaces for all users.
DBA_TS_QUOTAS	Provides information concerning tablespace quotas for all users.