Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] How to check what kind of objects on tablespace and dataf ile???

RE: [Q] How to check what kind of objects on tablespace and dataf ile???

From: Zhang, George <qzhang_at_ci.grand-rapids.mi.us>
Date: Thu, 19 May 2005 13:30:23 -0500 (EST)
Message-ID: <221C759285B78647AEE6181FD6AF36A7107252D0@bambi.grand-rapids.mi.us>


Query DBA_SEGMENTS:
Select segment_name, segment_type from dba_segments where tablespace_name = 'USERS'; George

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc
Sent: Tuesday, May 17, 2005 11:29 AM
To: oracle-l_at_freelists.org
Subject: [Q] How to check what kind of objects on tablespace and datafile???

I check ORACLE view "dba_tablespace", "dba_data_files" and "dba_objects". I can not find any object information. Does there has way to check what kind of Oracle objects (like tables, index, ..) in tablespace and datafiles?

Thanks.                 

Yahoo! Mail
Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 19 2005 - 14:39:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US