Mark,
If you use the PL/SQL utl_file package, this runs on the server, regardless
of where it is executed from, so can read the trace file. Furthermore, it
is executed as an 'oracle' owned process, so has the appropriate
permissions.
Let me know if you need any more help.
Cheers,
Steve
-----Original Message-----
From: Mark Wagner [mailto:[EMAIL PROTECTED]]
Sent: Friday, 23 March 2001 4:21 AM
To: [EMAIL PROTECTED]
Subject: Reading a trace file through Oracle? POSSIBLE??
I am working on making a tool with perl DBI/DBD Oracle to document Oracle
Databases... One of the things I want to do is back the control file
up to the trace file then read the trace file.
But heres the *hard* part:
I am not running this locally so using sql*net to connect to Oracle with
perl DBI/DBD, I need to make Oracle read the trace file in a way that
I can have it accessible by perl to print out.
Any help would be greatly appreciated.
Thanks
Mark
--
--------------------------------------------------------------------
Mark Wagner Phone - (510) 683-9681
Database Administrator [EMAIL PROTECTED]
* www.oralinux.org www.orasolaris.org www.orant.org *
* Dark Oracle of the Sysadmin Sith Darth SYSDBA *
--------------------------------------------------------------------
the shit ain't over till the last record spins.......
