Re: sql*loader utillity for importing text file into oracle

You can try putting a carriage return after the last line in your example.dat.

As a side issue, it would be better to use varchar2 instead of char in your table definition 'example'.

M

"Tomo" <tomislav.kokoska_at_vz.hinet.hr> wrote in message news:<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 Wed Nov 19 2003 - 15:57:50 CET