Re: Automatic Exports to Text Files

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Fri, 18 May 2001 02:20:23 GMT
Message-ID: <HF%M6.23626$p33.394742@news1.sttls1.wa.home.com>

Why can't you just connect to the database with a report writing tool? (e.g. Crystal reports, Access, et al) If you can issue queries to extract data to a flat file then it seems to me you could connect via a report writer of some sort. Then you save yourself a lot of extracting the data and copying it into some other database (it being out of date once you do that - but in certain situtions that may be fine.) and massaging. Seems like a lot of work.

2 ways. Use an NT at job or write an Oracle Job that uses the utl_file interface to write to one or more files. (dbms_job) Jim

"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 Thu May 17 2001 - 21:20:23 CDT