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 datafile???

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

From: amit poddar <amit.poddar_at_yale.edu>
Date: Tue, 17 May 2005 11:38:23 -0400
Message-ID: <428A0FEF.7060601@yale.edu>


check dba_segments

dba1 mcc wrote:

>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 Tue May 17 2005 - 11:51:27 CDT

Original text of this message

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