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

From: Natalia Laracca <nlaracca_at_afip.gov.ar>
Date: Thu, 18 Apr 2002 12:40:06 -0800
Message-ID: <F001.00448B14.20020418124006@fatcity.com>

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=5000000000 bad =/...../terminal.bad log =/........../terminal.log

Natalia L. Laracca

Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Thursday, April 18, 2002 4:49 PM

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: Natalia Laracca
  INET: nlaracca_at_afip.gov.ar

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 - 15:40:06 CDT