Re: Where are the files

From: Rob Forster <forstr_at_tdbank.ca>
Date: Tue, 29 Sep 1998 17:56:38 GMT
Message-ID: <qb9Q1.1002$vk7.4243574@news21.bellglobal.com>

select * from v$datafiles (or dba_data_files view) - for the names of the datafiles
v$controlfile - for the location(s) of the control files v$log - for the names of the redo logs

HTH,
Rob

Mark G. Woodruff wrote in message <6ur5d6$p4n$1_at_comet3.magicnet.net>...
>Is there some way of telling where Oracle7 is putting the various
>configuration files (init.ora, sqlnames.ora, *.dbf) from inside the
>database? Does Oracle squirrel away the paths somewhere in its various
>system tables in a way that can be queried using SQL?
>
>
>
Received on Tue Sep 29 1998 - 12:56:38 CDT