Re: help for SQL beginner

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 6 Mar 2005 07:14:15 -0500
Message-ID: <WYidnVj0p4uGabffRVn-ig@comcast.com>

"zeb" <spam_at_nowhere.com> wrote in message news:422ae928$0$27842$626a14ce_at_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/oramag/oracle/01-nov/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 Received on Sun Mar 06 2005 - 06:14:15 CST