Re: Tablespace

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