Can that be done through dbi?
if so, would you mind giving me an example??
Thanks
Mark
On Fri, Mar 23, 2001 at 07:58:45AM +1100, Steven Baldwin wrote:
> 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.......
--
--------------------------------------------------------------------
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.......
