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

From: Meomeo Nguyen <meomeo22_at_yahoo.com>
Date: Thu, 18 Apr 2002 15:53:22 -0800
Message-ID: <F001.00448F43.20020418155322@fatcity.com>

Hi All,
Thanks for all the replies. I do appreciate it. Finally, I successfully loaded data into the database, thanks to all your help. Trang
Natalia Laracca <nlaracca_at_afip.gov.ar> wrote: Hi, First, in a test' database, I would do: terminal.ctl LOAD DATA INFILE '/......./terminal.dat'
INTO TABLE TERMINAL
FIELDS TERMINATED BY ','
(

TERMINAL_POSITION_ID ,
TERMINAL_POSITION_NAME ,
TERMINAL_POSITION_DESCRIPTION

) terminal.sh sqlldr username/password control =/.........../terminal.ctl errors=5000000000bad =/...../terminal.bad log =/........../terminal.log Natalia L. Laracca

Original Message ----- From: Meomeo Nguyen To: Multiple recipients of list ORACLE-L Sent: Thursday, April 18, 2002 4:49 PMSubject: SQL*Loader question. Need a quick answer. Please

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 =/Di! ! sk05/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 - 18:53:22 CDT