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

[Meomeo Nguyen]

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 <[EMAIL PROTECTED]> 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=5000000000

bad =/...../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 PM

Subject: SQL*Loader question. Need a quick answer. Please

  Meomeo Nguyen <[EMAIL PROTECTED]> 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 m! ! essage 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

---

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

---

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