sql*loader utillity for importing text file into oracle

[Tomo]

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/ko***@beq-local.world control = 'example.ctl'
data='example.dat'
*******************
all files are placed in root c:\
PLEASE HELP ME!! WHERE I DID IT WRONG?!!

[SoulSurvivor]

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" <to**************@vz.hinet.hr> wrote in message news:<bp**********@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/ko***@beq-local.world control = 'example.ctl'
data='example.dat'
*******************
all files are placed in root c:\
PLEASE HELP ME!! WHERE I DID IT WRONG?!!

[Tomo]

it's all right, i put enter key at the and of data in control file and data
file...stuff working just fine!
Exaple i wrote was just simple problem...i tried on my real data(not
example) and job is done!!!
Thanks Daniel and Jonathan!!And Soul survivor on other newsgroup!!!
Best regards!! Tomo!!

[michael ngong]

"Tomo" <to**************@vz.hinet.hr> wrote in message news:<bp**********@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/ko***@beq-local.world control = 'example.ctl'
data='example.dat'
*******************
all files are placed in root c:\
PLEASE HELP ME!! WHERE I DID IT WRONG?!!

Is your text file very large?

Michael Tubuo Ngong