Re: Automatic Exports to Text Files

It's a long story about why I can't just do that. This machine, due to security reasons, sits on a standalone network consisting of only an IVR and this box, so the only actual machine we can get reports from (which we want to change anyway) is the box that houses Oracle. I found some code that I can dump a query to a file using the utl_file you suggested, but how do I schedule that to run automatically (i.e. what exactly do I have the "AT" job run)? Thanks again for all your help.

Rory

On Fri, 18 May 2001 02:20:23 GMT, "Jim Kennedy" <kennedy-family_at_home.com> wrote:

>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 - 22:00:40 CDT