Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Mailing Lists ->
Oracle-L ->
RE: Tablespace
RE: Tablespace
Very funny.
:)
- Rachel Carmichael <carmichr_at_hotmail.com> wrote:
> 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 |
> > >
> > >
> > >
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> 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).
Do You Yahoo!?
Received on Fri Apr 28 2000 - 13:44:32 CDT
Original text of this message