sql*loader utillity for importing text file into oracle
From: Tomo <tomislav.kokoska_at_vz.hinet.hr>
Date: Tue, 18 Nov 2003 21:08:28 +0100
Message-ID: <bpdu7r$q82$1_at_ls219.htnet.hr>
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 - 21:08:28 CET
Date: Tue, 18 Nov 2003 21:08:28 +0100
Message-ID: <bpdu7r$q82$1_at_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 - 21:08:28 CET