Re: Automatic Exports to Text Files

From: Giorgos Tsiamitas <gtsiam_at_gmx.net>
Date: Fri, 18 May 2001 09:20:35 GMT
Message-ID: <DP5N6.42$zt5.809@nreader2.kpnqwest.net>

since Oracle 7.3 you can schedule jobs in the Oracle server. See administrator's manual, chapter "Managing Job Queues" for details.

You will need to transfer you SQLs in PL/SQL procedures and use UTL_FILE package to spool results.

--
Giorgos

"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 - 04:20:35 CDT