RE: Tablespace

From: Janusz, Kenneth <Kenneth.Janusz_at_fingerhut.com>
Date: Thu, 27 Apr 2000 10:05:45 -0500
Message-Id: <10480.104325@fatcity.com>

But DBA_TABLESPACES and DBA_OBJECT_TABLES do have the TABLESPACE_NAME in them.

Ken

---

Kenneth C. Janusz, CPIM		FINGERHUT
Senior Technical Analyst		6150 Trenton Lane North, DC4N
					Plymouth, MN 55442

*Voice: 612.519.4403
*Email: kenneth.janusz_at_fingerhut.com

                  |\      _,,,---,,_         
            ZZZzz /,`.-'`'    -.  ;-;;,_ 
_________________|,4-  ) )-,_. ,\ (____-'___________________
                '---''(_/--'  `-'\_)	

"Dogs come when they're called; cats take a message and get back to you later." -- Mary Bly

---

-----Original Message-----
From: Sajid Iqbal [mailto:sajid_at_u-net.net] Sent: Thursday, April 27, 2000 9:48 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Tablespace

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:

> 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

Received on Thu Apr 27 2000 - 10:05:45 CDT