| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tablespace
--=_ORCL_5869907_0r0
Content-Type:text/plain; charset="iso-8859-1"
Content-Transfer-Encoding:quoted-printable
However, dba_segments does.
kimberly.smith_at_eds.com
--=_ORCL_5869907_0r0
content-type:message/rfc822
Date: 27 Apr 2000 07:48:16
From:Sajid Iqbal <sajid_at_u-net.net>
To:Multiple recipients of list ORACLE-L <ORACLE-L>
Subject:RE: Tablespace
Reply-to:UNIX.IOGMD:ORACLE-L_at_fatcity.com
Return-Path:root_at_fatcity.cts.com
Received:from gmd.fujitsu.com (ducks.gmd.fujitsu.com [198.6.119.2]) by hdoc02.gmd.fujitsu.com with SMTP (8.7.1/8.7.1) id HAA29385 for <ksmith1.ofcmail_at_hdbi01>; Thu, 27 Apr 2000 07:31:10 -0700 (PDT) Received:from dfwl01.gmd.fujitsu.com by gmd.fujitsu.com (SMI-8.6/) id HAA19864; Thu, 27 Apr 2000 07:31:04 -0700 Received:from dfwl01.gmd.fujitsu.com (root_at_localhost) by dfwl01.gmd.fujitsu.com with ESMTP id HAA13097 for <ksmith1_at_gmd.fujitsu.com>; Thu, 27 Apr 2000 07:31:04 -0700 (PDT) Received:from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199]) by dfwl01.gmd.fujitsu.com with ESMTP id HAA13093 for <ksmith1_at_gmd.fujitsu.com>; Thu, 27 Apr 2000 07:31:03 -0700 (PDT) Received:from fatcity.UUCP (uucp_at_localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id HAA93440; Thu, 27 Apr 2000 07:30:52 -0700 (PDT) Received:by fatcity.com (02-Mar-2000/v1.0f-b68/bab) via UUCP id 0015251A; Thu, 27 Apr 2000 06:48:16 -0800Message-ID:<F001.0015251A.20000427064816_at_fatcity.com> X-Comment:Oracle RDBMS Community Forum
DBA_OBJECTS does not have tablespace_name in it !
Saj
-- 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 | On Thu, 27 Apr 2000, Bruce Page wrote:Received on Thu Apr 27 2000 - 10:07:23 CDT
> select object_name, object_type
> from dba_objects
> where tablespace_name = 'XXX';
>
>
> -----Original Message-----
> Sent: Thursday, April 27, 2000 7:35 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
>
-- 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). --=_ORCL_5869907_0r0-- ------------------------------ From: "Rachel Carmichael" <carmichr_at_hotmail.com> Date: Thu, 27 Apr 2000 15:15:11 GMT Subject: Re: Tablespace Actually that won't work.. there is no tablespace_name in dba_objects what you can do is select segment_name, segment_type from dba_segments where tablespace_name ='the tablespace you want' >From: bill thater <thaterw_at_telergy.net> >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 06:16:00 -0800 > >At 08:35 AM 4/27/00, Sajid Iqbal scribbled on the wall with glitter crayon: >>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 >
> ^^^^
> DBA_OBJECTS
> > >>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). > >-- >Bill Thater Certified ORACLE DBA >Telergy, Inc. thaterw_at_telergy.net >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Do or not do. There is no try. -- Yoda >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >History does not repeat itself. Historians repeat each other. - Arthur >Balfour (1848-1930) > > > >-- >Author: bill thater
> INET: thaterw_at_telergy.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). ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ------------------------------ From: "Madhavan Amruthur" <mad012000_at_hotmail.com>
 |
 |