Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to list all db files

How to list all db files

From: wane <nospam_at_intechs.net>
Date: Thu, 08 Apr 2004 18:32:50 -0400
Message-ID: <c54jui$2oo6bt$1@ID-18576.news.uni-berlin.de> 





Hello,


I am running Oracle 8.1.7.4 on AIX 5.2. I am using this query to get a 
list of all datafiles in the database. But after verification, it looks 
like some datafiles are not listed. What is the best approach? I am 
using raw partitions (logical volumes).



select file_name from dba_data_files.



Thanks.
Received on Thu Apr 08 2004 - 17:32:50 CDT












Original text of this message













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