Re: Backup controlfile to trace

> All,
>
> I have a job 'alter database backup controlfile to trace'. How can I automate the process of
> locating the trace file and copying to somewhere else? Thanks.
>
> W2K + 9.2.0.3
>
> - Jack

Jack,

Look at the sql statement on my website: http://www.adp-gmbh.ch/ora/misc/find_trace_file.html

That should give you an idea of how to locate a trace file.

hth for the first part of your question

Rene  

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch