Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Anand.

Asked: April 22, 2025 - 5:13 pm UTC

Last updated: April 23, 2025 - 7:38 am UTC

Version: Oracle 19c

Viewed 100+ times

You Asked

How do I know which tablespaces have which data files and their path on disk?

and Connor said...

Isn't that just a case of querying DBA_DATA_FILES ?

SQL> select tablespace_name, file_name from dba_data_files;

TABLESPACE_NAME      FILE_NAME
-------------------- ----------------------------------------------
SYSTEM               X:\ORADATA\DB21\PDB21A\SYSTEM01.DBF
SYSAUX               X:\ORADATA\DB21\PDB21A\SYSAUX01.DBF
UNDOTBS1             X:\ORADATA\DB21\PDB21A\UNDOTBS01.DBF
USERS                X:\ORADATA\DB21\PDB21A\USERS01.DBF
ASKTOM               X:\ORADATA\DB21\PDB21A\ASKTOM.DBF
SOE                  X:\ORADATA\DB21\PDB21A\SOE.DBF


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Multitenant

Need more information on Multitenant? Check out the Multitenant docs for the Oracle Database