Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Loader Question

Re: SQL*Loader Question

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Mon, 07 Aug 2000 18:19:18 -0400
Message-Id: <10582.114019@fatcity.com>


Yes. You can pass in everything as a command line option. To get help on the options do:

sqlldr help=3Dy

=46or a simple load, you end up doing something like this:

sqlldr control=3Dc:\filename.ctl file=3Dc:\yourfile.dat log=3Dc:\yourlog.dat

regards,

Jonathan



jonathan_at_gennick.com =20
http://gennick.com
Brighten the Corner Where You Are

On Mon, 07 Aug 2000 10:04:36 -0800, you wrote:

>Is there a way to execute SQL*Loader in batch mode? I would like to =
script
>the loading of several tables using SQL*Loader but I cannot find any
>documentation on the subject. I'm on Oracle 8.1.5 and Windows NT. I can
>invoke a sqlldr command from the windows command prompt successfully but
>batch mode would be much better. Thanks in advance.
Received on Mon Aug 07 2000 - 17:19:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US