Yes you can set up a cron job that will invoke a SQL script that turns
spooling on, runs as many queries, updates, inserts, etc. as you want, turn
spooling off, and then exit.
Once you have a working SQL script just have your friendly system
administrator set it up as a cron job. run by the appropriate user
account).
regards
Jerry Gitomer
janicey_at_my-dejanews.com wrote in message <7hf0b2$gkf$1_at_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 Fri May 14 1999 - 08:14:48 CDT
