Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sql*loader import file into oracle

sql*loader import file into oracle

From: Tomo <tomislav.kokoska_at_vz.hinet.hr>
Date: Tue, 18 Nov 2003 21:11:14 +0100
Message-ID: <bpdud0$qcn$1@ls219.htnet.hr>


I'm trying to import text file into some oracle table. I created control file, and text file, create table ..and run sqlldr80 from command promt..
Imort was not succesfull..error occurs..sql*loader-524:partial record found at end of data file (proba.ctl)
See what i done, and please help me..
CREATING TABLE



create tabale example(
column1 number(3),
column2 char(3))

CREATING CONTROL FILE

LOAD DATA
INFILE 'EXAMPLE.DAT'
INTO TABLE EXAMPLE
(COLUMN1 POSITION (01:03) INTEGER EXTERNAL,  COLUMN2 POSITION (04:06) CHAR)

CONTENT OF EXAMPLE.DAT FILE (after "C" Carriage Return)

123ABC
234DEF

text written in command prompt

sqlldr80 tomo/kokos_at_beq-local.world control = 'example.ctl' data='example.dat'

all files are placed in root c:\
PLEASE HELP ME!! WHERE I DID IT WRONG?!! Received on Tue Nov 18 2003 - 14:11:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US