Message-Id: <10480.104320@fatcity.com> From: Bruce Page Date: Thu, 27 Apr 2000 09:44:22 -0500 Subject: RE: Tablespace This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFB057.205A4676 Content-Type: text/plain; charset="iso-8859-1" That must be something that changed between 7.3.4 and 8. It works in 7.3.4. -----Original Message----- From: Deshpande, Kirti [mailto:Kirti.Deshpande@gtedc.gte.com] Sent: Thursday, April 27, 2000 8:40 AM To: ORACLE-L@fatcity.com Cc: bpage@kimball.com Subject: RE: Tablespace That won't work. DBA_OBJECTS does not have tablespace_name. Try DBA_SEGMENTS instead, (or DBA_TABLES & DBA_INDEXES) - Kirti > -----Original Message----- > From: Bruce Page [SMTP:bpage@kimball.com] > Sent: Thursday, April 27, 2000 9:16 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Tablespace > > select object_name, object_type > from dba_objects > where tablespace_name = 'XXX'; > > > -----Original Message----- > From: Sajid Iqbal [ ] > Sent: Thursday, April 27, 2000 7:35 AM > 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@u-net.net > Database DBA/Developer | Ext : 4485 > U-NET Ltd | ICQ : 43903417 > Warrington, Cheshire, UK | > > > ------_=_NextPart_001_01BFB057.205A4676 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Tablespace

That must be something that changed between 7.3.4 and = 8.

It works in 7.3.4.

-----Original Message-----
From: Deshpande, Kirti [mailto:Kirti.Deshpande@gte= dc.gte.com]
Sent: Thursday, April 27, 2000 8:40 AM
To: ORACLE-L@fatcity.com
Cc: bpage@kimball.com
Subject: RE: Tablespace


That won't work.

DBA_OBJECTS does not have tablespace_name.

Try DBA_SEGMENTS instead, (or DBA_TABLES & = DBA_INDEXES)

- Kirti

> -----Original Message-----
> From: Bruce Page = [SMTP:bpage@kimball.com]
> Sent: Thursday, April 27, 2000 9:16 AM
> To:   Multiple recipients of list = ORACLE-L
> Subject:      RE: = Tablespace
>
> select object_name, object_type
> from dba_objects
> where tablespace_name =3D 'XXX';
>
>
> -----Original Message-----
> From: Sajid Iqbal [ <mailto:sajid@u-net.net>]
> Sent: Thursday, April 27, 2000 7:35 AM
> 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 =3D xxx
>
> using Oracle 8.0.4.0
>
> TIA
>
> Saj Iqbal
>
> --
> U-NET Ltd  a VIA NET.WORKS Inc company =
> Sajid = Iqbal           &= nbsp;        | Mail : = sajid@u-net.net
> Database = DBA/Developer         | = Ext  : 4485
> U-NET = Ltd           &nb= sp;          | ICQ  : = 43903417
> Warrington, Cheshire, = UK       |