Re: Automatic Exports to Text Files

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 18 May 2001 11:32:00 +0100
Message-ID: <990181927.22903.0.nnrp-07.c30bdde2@news.demon.co.uk>

Rory

At the simplest level, you could use an at job to call a batch file that uses SQL*Plus to output the file. Hence you don't need to bother with UTL_FILE and DBMS_JOB etc.

"Rory Tripp" <rtripp_at_xmission.com> wrote in message news:3b04801c.699475182_at_news...
> Sorry for posting a stupid question, but I'm new to Oracle. Our
> vendor stores its data in an Oracle 7 database on NT Server 4.0, and
> up until now we haven't really been able to get it besides their
> canned reports. What I want to do is to schedule a job to
> automatically export the previous day's data in the tables. I can
> write the SQL statements fine, and I can manually spool it, but how
> can I get it to do it automatically each night? Thanks for any help
> you have.
>
>
Received on Fri May 18 2001 - 05:32:00 CDT