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

"zeb" <spam@nowhere.com> wrote in message
news:422ae928$0$27842$626a14ce@news.free.fr...
> 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 ...
>
>
>

what have you tried? post it along with the db version and any error
messages you get

meanwhile, here's some references:

http://tahiti.oracle.com lists the manuals, you should download the SQL and
Concepts manuals

google'ng on ORACLE JOIN SYNTAX is a good idea too, it will get you stuff
like
http://www.oracle.com/technology/ora...ov/o61sql.html
and http://www.psoug.org/reference/joins.html

Oracle By Example at Oracle Technology Network is also a good resource:
http://www.oracle.com/technology/obe/start/index.html

++ mcs

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@x.washington.edu
(replace 'x' with 'u' to respond)