Re: Loader

From: <effler_at_yahoo.com>
Date: Tue, 04 Apr 2000 06:39:53 GMT
Message-ID: <8cc2no$17f$1@nnrp1.deja.com>

Example of SQL-LOADER Call from DOS Prompt

drive:\ORACLEHOME\bin\sqlldr parfile=drive:\pfad\parameterfile.prm

You have to create 2 ASCII-files (without lines beginning with #) - parameterfile
- controlfile

###################

# parameterfile.prm

###################

userid=USER/PASSWORT
control=drive:\path\Controlfile.ctl
data=drive:\path\DATAFILE
log=drive:\path\idsread.log
bad=drive:\path\idsread.bad
# EOF ############# The example for Controlfile is for "defined Width" not for csv

append - is recommended to make the load faster in line 3 an 7 are Conditions defined, you can load from one datafile in different tables according to the data in the Textfile in line 4-6,8-10 is defined which data goes to which column (as i said i use a datafile with defined witdh)

###################

# Controlfile.ctl

###################

load data
append
into table MyTable1 when (35:36)='6 ' AND (1:7)='EEX3287' (Racfid POSITION(1:8) CHAR,
.......
aek_fkz_text POSITION(288:288) CHAR)
into table MyTable2 when (35:36)='3 ' AND (1:7)='EEX3287' (Racfid POSITION(1:8) CHAR,
........
frtxt4 POSITION(275:353) CHAR)
# EOF ############# In article <8cbtad$aos$1_at_is-news.gov.ab.ca>, "Karen Schmidt" <Kschmidt_at_audg.gov.ab.ca> wrote:
> I am running Oracle 7.3. Using DataManager's loader to load a csv file
> into the database. Is it possible to run the loader from sql or the
command
> line (or batch file) ?

>

> Thanks....

>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Apr 04 2000 - 01:39:53 CDT