RE: Tablespace

From: Philip West <P.West_at_g-icap.com>
Date: Thu, 27 Apr 2000 14:01:46 +0100
Message-Id: <10480.104296@fatcity.com>

select owner,segment_name,segment_type from dba_segments

> -----Original Message-----
> From: Sajid Iqbal [SMTP:sajid_at_u-net.net]
> Sent: Thursday, April 27, 2000 1:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Tablespace
>
> 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
>
> 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).

---

The information in this Internet e-mail is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.  When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients.

Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc.

---

Received on Thu Apr 27 2000 - 08:01:46 CDT