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

From: Hollis, Les <Les.Hollis_at_ps.net>
Date: Tue, 17 May 2005 10:48:42 -0500
Message-ID: <683E0A1C82D75246BD9F4E01F77CBB0F628D27@pscdalpexch02.perotsystems.net>

Select segment_name, segment_type from dba_segments where tablespace_name =3D'YADA';

Info is contained in DBA_SEGMENTS

-----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 10: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.

=09
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 Tue May 17 2005 - 11:54:03 CDT