Re: Delete Datafile and Recover DB Without Using Backup?

Paul,

I'm trying to remember what OS you run oracle on. If its win32, download the utility filemon from Sysinternals and filter to just the %ORACLE_HOME%\network\admin directory ... and you'll have your answer.

procviewer will list files currently open, but doesn't have the logging features that filemon does.

Paul

On Fri, 25 Feb 2005 12:24:49 -0000, Paul Vincent <Paul.Vincent_at_uce.ac.uk> wrote:
> I'm trying to create a db link from a 9i database to an 8i database on
> another server. I've edited the tnsnames.ora file for the 9i database,
> adding an entry for the 8i database, and created the link on the 9i
> database, using OEM. But when I test the link in OEM (by clicking
> "Test"), the alert box tells me the link is not active. Do I need to
> bounce the 9i database so that it picks up the altered tnsnames.ora
> file? That is, does Oracle only scan the tnsnames.ora file at startup,
> or should it look afresh at the tnsnames.ora file each time name
> resolution is required?
>
> Thanks,
>
> Paul Vincent
> DBA
> University of Central England
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
http://www.freelists.org/webpage/oracle-l