Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLLOADER fails
2 Ideas...
First, run it without the direct option and watch the messages sent by SqlLoader
-
Or
move the *.dat file to the same location as SqlLoader - sometimes
I have found a problem with how SqlLoader resolves the path in the infile
section...
Hope it helps,
andrea_johnson_at_wolfe.net wrote:
>ORACLE 8.04/solaris
>
>I'm really at a loss. Please give me some in depth feedback because I do not
>understand why this seemingly simple load fails.
>
>I'm trying to load some 18,000 records.
>
>The .dat file is tab delimited
>
>Using direct=true
>
>The process starts and then just hangs--never completing--I've been killing
>the process manually through the O/S.
>
>I've removed the table and recreated it without an index--thinking it was the
>sorting that was causing the problem. At this point the table is empty--but
>eventually I'll need to replace the data with future loads.
>
>WHAT AM I DOING WRONG! Where can I look to see what I've messed
>up/configured incorrectly...(thanks in advance)
>
>This is my .ctl file:
>
>LOAD DATA
>INFILE '/oracle/or0/SQL-load-files/customermaster/CLIENTS-CONVERT.dat'
>TRUNCATE
>DISCARDMAX 18000
>INTO TABLE pub.customermaster
>FIELDS TERMINATED BY X'09'
>( account
>,email
>,lastName
>,firstName
>,companyName NULLIF companyName=BLANKS
>,billTo NULLIF billTo=BLANKS
>,billAddress
>,billCity NULLIF billcity=BLANKS
>,billState NULLIF billState=BLANKS
>,billZip NULLIF billzip=BLANKS
>,Address
>,City NULLIF City=BLANKS
>,State NULLIF State=BLANKS
>,Zip NULLIF Zip=BLANKS
>,dayPhone
>,evePhone NULLIF evePhone=BLANKS
>,fax NULLIF fax=BLANKS
>,preferPhone NULLIF preferPhone=BLANKS
>,billNotify NULLIF billNotify=BLANKS
>,paymentMethod NULLIF paymentMethod=BLANKS
>,platform NULLIF platform=BLANKS
>,homePOP
>,source NULLIF source=BLANKS
>,activationdate DATE "yyyymmdd" NULLIF activationdate=BLANKS
>,comments NULLIF comments=BLANKS
>,salesperson NULLIF salesperson=BLANKS
>,doneBy
>,deactivationdate DATE "yyyymmdd" NULLIF deactivationdate=BLANKS
>,lastProvider NULLIF lastProvider=BLANKS
>,socSec NULLIF socSec=BLANKS
>,birthDate DATE "yyyymmdd" NULLIF birthDate=BLANKS
>,billlastname NULLIF billlastname=BLANKS
>,billfirstname NULLIF billfirstname=BLANKS
>)
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
To reply please remove the 'nospam' part of the address Received on Mon Mar 29 1999 - 14:42:24 CST