Re: Oracle 7.3 and Data Manager

BC Computing Limited <BCCOMP_at_bccomp.demon.co.uk> wrote:

>Hi,
>
> Does anyone know how to run SQL*Loader from a command line, instead of
> through 'Data Manager'?, the older versions let you set up icons to do
> data loads and write TSR procedures to 'fire off' automatic data loads
> from other data sources, but I just can't do it anymore. Have I missed
> something, or is this another 'product improvement' ?

I still use SqlLoader from a command line[ Windows95 DOS box] ( in fact I use the same .bat file I have used since 7.1.4 ) . It works fine.

Here it is - I pass the *.ctl file name to it ( i.e. loadit employee )

REM Uses the current Sqlload
 d:\orawin95\bin\SQLLDR userid/pswrd control=%1.ctl bad=%1.bad errors=500 log=%1.log

Hope it helps,

John.Greco_at_dot.state.mn.us Received on Thu May 29 1997 - 00:00:00 CEST