Re: How to list all db files

From: DJ <nospamplease_at_goaway.com>
Date: Fri, 9 Apr 2004 01:03:13 +0100
Message-ID: <%Kldc.13391$4N3.1098@newsfe1-win>

"wane" <nospam_at_intechs.net> wrote in message news:c54jui$2oo6bt$1_at_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.
>

dba_temp_files

v$log
v$controlfile

probably others Received on Thu Apr 08 2004 - 19:03:13 CDT