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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc Sent: Tuesday, May 17, 2005 10:29 AM To: oracle-l@xxxxxxxxxxxxx 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