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: Which file an object resides in.

RE: Which file an object resides in.

From: Ruiz, Mary A (CAP, CDI) <Mary.Ruiz_at_gecapital.com>
Date: Tue, 21 Nov 2000 09:50:47 -0500
Message-Id: <10687.122613@fatcity.com> 





Just wanted to add a couple of things to the script.



SELECT  distinct e.segment_name, f.file_name
FROM    DBA_EXTENTS E  ,  DBA_DATA_FILES F 

WHERE   E.FILE_ID = F.FILE_ID



and 	  e.segment_name = upper('&Your_object');



Mary Ruiz / Atlanta, GA
Received on Tue Nov 21 2000 - 08:50:47 CST












Original text of this message













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