Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tablespace
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
|\ _,,,---,,_ 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 mayReceived on Thu Apr 27 2000 - 10:05:45 CDT
![]() |
![]() |