By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,718 Members | 1,840 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,718 IT Pros & Developers. It's quick & easy.

sql*loader utillity for importing text file into oracle

P: n/a
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?!!
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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?!!

Jul 19 '05 #2

P: n/a
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!!

Jul 19 '05 #3

P: n/a
"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
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.