RE: sql help

From: Kevin Lange <kgel_at_ppoone.com>
Date: Mon, 23 Jul 2001 07:28:23 -0700
Message-ID: <F001.00351923.20010723065554@fatcity.com>

select distinct segment_type, owner, segment_name, tablespace_name from dba_segments

This will get them all in one simple query.

-----Original Message-----
Sent: Saturday, July 21, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L

hi dba's

how to find out a users all objects+the tablespaces in which they reside.

i tried using the flwng way:

select tablespacename,table_name from dba_tables where obj in (select obj_nm from dba_objects where obj_type ='table' and owner='xyz')
union

select for indexes

union

select for clusters
;

can anybody tell me any alternative statement for the above.

thnx in adv.

srinivas

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: kommareddy sreenivasa
INET: kommacnu_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------