Find Datafiles Associated with Tablespace

FIND TABLESPACES IN DATABASE

select name from v$tablespace;

OR

select tablespace_name from dba_tablespaces;

QUERY TO FIND DATAFILES ASSOCIATED WITH A TABLESPACE

SQL> select tablespace_name, file_name, bytes/1024/1024 from dba_data_files where tablespace_name='&tablespace_name';
SQL> select file_name, bytes/1024/1024 from dba_temp_files;

Was this article helpful?

Related Articles

Leave a Comment