Re: Tablespace

Actually that won't work.. there is no tablespace_name in dba_objects

what you can do is

select segment_name, segment_type from dba_segments where tablespace_name ='the tablespace you want'

>From: bill thater <thaterw_at_telergy.net>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Tablespace
>Date: Thu, 27 Apr 2000 06:16:00 -0800
>
>At 08:35 AM 4/27/00, Sajid Iqbal scribbled on the wall with glitter crayon:
>>Hello All
>>
>>How can I tell what objects are in a particular tablespace
>>eg
>>select object_name, object_type from xxxx where tablespace_name = xxx
>
> ^^^^
> DBA_OBJECTS
>
>
>>using Oracle 8.0.4.0
>>
>>TIA
>>
>>Saj Iqbal
>>
>>--
>>U-NET Ltd a VIA NET.WORKS Inc company
>>Sajid Iqbal | Mail : sajid_at_u-net.net
>>Database DBA/Developer | Ext : 4485
>>U-NET Ltd | ICQ : 43903417
>>Warrington, Cheshire, UK |
>>
>>
>>--
>>Author: Sajid Iqbal
>> INET: sajid_at_u-net.net
>>
>>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).
>
>--
>Bill Thater Certified ORACLE DBA
>Telergy, Inc. thaterw_at_telergy.net
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Do or not do. There is no try. -- Yoda
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>History does not repeat itself. Historians repeat each other. - Arthur
>Balfour (1848-1930)
>
>
>
>--
>Author: bill thater
> INET: thaterw_at_telergy.net
>
>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).