hi

I try to get file_name and size
for tablespace having objects from USER1

I tried some joins with this two queries
but no success, can you help me ?


select tablespace_name
from dba_segments
where owner = 'USER1'
group by tablespace_name

select tablespace_name, file_name, bytes
from dba_data_files
where tablespace_name='rows from above query'


Thanks in advance ...