RE: Tablespace

you must have a version of 7.3.4 that I don't :

Oracle7 Server Release 7.3.4.0.1 - Production With the distributed option
PL/SQL Release 2.3.4.0.0 - Production

SQL> desc dba_objects

Name                            Null?    Type
------------------------------- -------- ----
OWNER                                    VARCHAR2(30)
OBJECT_NAME                              VARCHAR2(128)
OBJECT_ID                                NUMBER
OBJECT_TYPE                              VARCHAR2(13)
CREATED                                  DATE
LAST_DDL_TIME                            DATE
TIMESTAMP                                VARCHAR2(75)
STATUS                                   VARCHAR2(7)

SQL> I don't see tablespace_name there

Rachel

>From: Bruce Page <bpage_at_kimball.com>
>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 18:08:35 -0800
>
>That must be something that changed between 7.3.4 and 8.
>
>It works in 7.3.4.
>
>-----Original Message-----
>Sent: Thursday, April 27, 2000 8:40 AM
>To: ORACLE-L_at_fatcity.com
>Cc: bpage_at_kimball.com
>
>
>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 |
> >
> >
> >