Automate SQL Loader in Windows NT...??

From: Eli <cohens_at_bestweb.net>
Date: 22 Jul 2002 10:23:01 -0700
Message-ID: <899d7e4d.0207220923.60af7ed4_at_posting.google.com>

I am working in a Windows NT environment and am currently developing a script to be run in Oracle 8i. One of my base tables consists of an email_address column and a count_distinct_email_address column. I am currently manually uploading the tab delimited file using SQL Loader - one click (I created a short cut with the command line opening Loader and pointing to the .ctl and .log file). The problem is, I have to perform two steps. Upload the file using SQL Loader, and then run the script in order to create my final results.

Does anyone know of a way to automatically run SQL Loader from within my .sql (script) file?

Eli Received on Mon Jul 22 2002 - 19:23:01 CEST

This message: [ Message body ]
Next message: Kelly: "runInstaller gives:bash: ./runInstaller: bad interpreter: Permission denied (RH 7.1/Oracle 8.1.6)"
Previous message: Maggie: "Parallel Server and Oracle9i RAC - who actually uses this ?"
Next in thread: Finn Ellebaek Nielsen: "Re: Automate SQL Loader in Windows NT...??"
Reply: Sybrand Bakker: "Re: Automate SQL Loader in Windows NT...??"
Reply: Finn Ellebaek Nielsen: "Re: Automate SQL Loader in Windows NT...??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message