help for SQL beginner

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 ... Received on Sun Mar 06 2005 - 05:29:37 CST