Re: help for SQL beginner

zeb wrote:

> 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 ...

Join dba_segments and dba_data_files
where segment_owner = 'USER1'

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)