Tablespace and data file information can also be obtained by querying the following:
- Tablespace information:
- DBA_TABLESPACES
- V$TABLESPACE
- Data file information:
- DBA_DATA_FILES
- V$DATAFILE
The V$DBFILE view displays all data files in the database. This view is retained for historical compatibility. Use of V$DATAFILE is recommended instead.
- Temp file information:
- DBA_TEMP_FILES
- V$TEMPFILE
