Re: SQL*Loader (SQLLDR.EXE)

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Thu, 14 Feb 2002 06:21:39 +1100
Message-ID: <3c6abccf$0$27942$afc38c87@news.optusnet.com.au>

At the command prompt, you do:

C:\Oracle> sqlldr system/manager_at_db1 control=<name of controlfile> log=<name of logfile> direct=<true or false> data=<name of data file> bad=<name of bad file> discard=<name of discard file> discardmax=<max number of records to discard> errors=<maximum number of bad records to permit> ...

...and so on. In other words, SQL Loader is a user process that has to connect to the database just as you have to do when you run SQL Plus.

For a list of the complete set of command line parameters, have a look at the Oracle8i utilities manual at technet.oracle.com, and look for "SQL Loader Command Line Reference".

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"george lewycky" <gelewyc_at_nyct.com> wrote in message
news:68aecc05.0202130842.61d7805c_at_posting.google.com...


> im trying to use SQL*Loader (SQLLDR.EXE) to load a flat

> file into a database I created.

>

> how do i login and then enter the code into this dos based

> application ??

>

> is there another interface, etc after i log on??

>

> any examples, references, web sites i would appreciate

>

> george lewycky

Received on Wed Feb 13 2002 - 13:21:39 CST