Spool to Common Log Format

From: <janicey_at_my-dejanews.com>
Date: Thu, 13 May 1999 16:58:14 GMT
Message-ID: <7hf0b2$gkf$1@nnrp1.deja.com>

I need to create Common Log Format text files from our Oracle tables for auditing purposes.

In Perl I wrote a Select->Fetch->Print <outfile> routine that selects, then writes the rows one at a time. Given our volume (2 million+ a day) I’m concerned this might be very slow.

I know in SQLPLUS I can turn on SPOOL then do a select to accomplish this but this process has to run unattended as a cron job.

The question(s) is:
1) Can I somehow do the SPOOL in Perl or PL/SQL to avoid the one at a time select->fetch row processing?
-or-

2) Can I write a script to start up SQLPLUS and execute a statement block that includes the SPOOL?
-or-

any other suggestions

--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
Received on Thu May 13 1999 - 11:58:14 CDT