Xref: alice comp.databases.oracle.tools:42217
Path: alice!news-feed.fnsi.net!cyclone.i1.net!newsfeed.enteract.com!newsfeed.berkeley.edu!news.ecn.ou.edu!news1.optus.net.au!optus!news.mel.connect.com.au!not-for-mail
From: "Tom Zamani" <tomz@redflex.com.au>
Newsgroups: comp.databases.oracle.tools
Subject: Re: DataManager Load
Date: Tue, 4 Apr 2000 15:05:14 +1000
Organization: Customer of Connect.com.au Pty. Ltd.
Lines: 43
Message-ID: <8cbtjm$jl6$1@perki.connect.com.au>
References: <8cbsln$af0$1@is-news.gov.ab.ca>
X-Trace: perki.connect.com.au 954825142 20134 203.63.133.169 (4 Apr 2000 05:12:22 GMT)
X-Complaints-To: abuse@connect.com.au
NNTP-Posting-Date: 4 Apr 2000 05:12:22 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

Yes it is.
You can use sql loader from command line.
first you need to creat a control file.
aard.ctl is your control file which contains:

    load data
    infile 'aard'    The actual datafile  name is aard.dat oracle will put
the .dat at the end of it. If datafile is not in the same directory then
enter the path as well
    insert            it could be insert or append
    into table aard
    fields terminated by '|'
    (
    ar_key,
    ar_bacat,
    ar_lib,
    ar_oms
    ar_date  date "DD/MM/YYYY" NULLIF ar_date=BLANKS,   if you have a column
with type date enter the date format
    )

then
enter command line
sqlload userid=user/password@connect string control=aard.ctl direct=true
bad=badfile.bad loag=logfile.log
direct =true is fast but you need to build the index(s)
direct =FAlse is sllow  updates the index(s) as inserts.
Tom



Karen Schmidt <Kschmidt@audg.gov.ab.ca> wrote in message
news:8cbsln$af0$1@is-news.gov.ab.ca...
> 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....
>
>