- Arun Kumar
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;