Oracle-L: SQL*Loader question. Need a quick answer. Please

From: Meomeo Nguyen <meomeo22_at_yahoo.com>
Date: Thu, 18 Apr 2002 11:49:12 -0800
Message-ID: <F001.0044895D.20020418114912@fatcity.com>

Meomeo Nguyen <meomeo22_at_yahoo.com> wrote: Hi List,

Below are my control and data files:(both files are stored on /Disk05)

terminal.ctl file:

LOAD DATA
INFILE = ‘Disk05/terminal.dat’
INTO TABLE TERMINAL_POSITION
FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”’
(

TERMINAL_POSITION_ID VARCHAR2 TERMINATED BY “,” ENCLOSED BY ‘”’, TERMINAL_POSITION_NAME VARCHAR2 TERMINATED BY “,” ENCLOSED BY ‘”’,
TERMINAL_POSITION_DESCRIPTION VARCHAR2 TERMINATED BY “,” ENCLOSED BY ‘”’
)

terminal.dat file:

A,Axial,Terminals extend from both ends in the direction of the major axis of a cylindrical or elliptical package.
B,Bottom,Terminals extend from the bottom of the package.
D,Dual,Terminals are on opposite sides of a square or rectangular package or located in two parallel rows.

for any reason, when entering
sqlldr username/password control = /Disk05/terminal.ctl log =/Disk05/terminal.log data = '/Disk05/terminal.dat'

an error message shows:
segmentation fault.

Alternatively, when issuing
sqlldr userid = username/password control = /Disk05/terminal.ctl log =/Disk05/terminal.log data = '/Disk05/terminal.dat'

an error message shows:

lf iopn failed for file (terminal.log)

Please note that: I did create terminal.log that is stored on /Disk05 as well. Please anyone point out what did I do wrong. Your help is greatly appreciated.

Thanks
Trang

Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Meomeo Nguyen
  INET: meomeo22_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Thu Apr 18 2002 - 14:49:12 CDT