Re: Automatic Exports to Text Files

From: Dmitry <support_at_ispirer.com>
Date: Fri, 18 May 2001 13:28:19 +0300
Message-ID: <9e2tm3$pptq$1@ID-75577.news.dfncis.de>

Hi,

You can use Chyfo (http://www.ispirer.com/products/) to do this. This is easy-to-use command prompt tool (40K) that can export Oracle data to text files (CSV, TAB delimited, fixed length). You can provide any SELECT statement and create batch scripts to automatically export data.

Best regards, Dmitry.

"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:28:19 CDT