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