RE: Tablespace

From: Bruce Page <bpage_at_kimball.com>
Date: Thu, 27 Apr 2000 09:44:22 -0500
Message-Id: <10480.104320@fatcity.com>

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_at_gtedc.gte.com] Sent: Thursday, April 27, 2000 8:40 AM
To: ORACLE-L_at_fatcity.com
Cc: bpage_at_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_at_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 [ <mailto:sajid_at_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 = 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       |  
> 
> 
>

------_=_NextPart_001_01BFB057.205A4676
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: Tablespace</TITLE>
</HEAD>
<BODY>

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


It works in 7.3.4.


-----Original Message-----
 From: Deshpande, Kirti [<A =
HREF=3D"mailto:Kirti.Deshpande_at_gtedc.gte.com">mailto:Kirti.Deshpande_at_gte= dc.gte.com</A>]
 Sent: Thursday, April 27, 2000 8:40 AM
 To: ORACLE-L_at_fatcity.com
 Cc: bpage_at_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_at_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 [ <<A =
HREF=3D"mailto:sajid_at_u-net.net">mailto:sajid_at_u-net.net</A>>] 
 > 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_at_u-net.net 
 > Database =

DBA/Developer         | = Ext  : 4485 
 > U-NET =

Ltd           &nb= sp;          | ICQ  : = 43903417 
 > Warrington, Cheshire, =
UK       |  Received on Thu Apr 27 2000 - 09:44:22 CDT