Check which table is belong to which tablespace

select t.table_name,t.tablespace_name,df.file_name from dba_tables t, dba_data_files df
where t.tablespace_name = df.tablespace_name and t.tablespace_name not in( ‘SYSAUX’,’SYSTEM’)
order by t.table_name;

One thought on “Check which table is belong to which tablespace”

Leave a Reply

Your email address will not be published. Required fields are marked *