Re: Help:Trace file name * I have similar Question *

Is there any tables that contain the name of the trace file created?

I want to do an:

alter database backup controlfile to trace;

Then know the nae of the file so that i can use the utl_file package

to access that file.

But how do i find out the name of the file with out executing OS commands?

Thanks

Mark Wagner

"DODO" <dodo_at_Ihatespam.com> wrote in message news:UmLu6.165830$Z2.2039566_at_nnrp1.uunet.ca...
> Hello,
> Does anyone know how Oracle names its trace files? I mean, after issuing
 the
> ALTER SESSION SET SQL_TRACE = TRUE command, a .trc file is created on the
> server. If you delete that file a new file with the same name is created,
 so
> it is consistent.
> TIA,
> DODO
>
>
Received on Fri Mar 23 2001 - 14:48:54 CST