473,320 Members | 1,926 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

sql*loader utillity for importing text file into oracle

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
3 17769
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
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
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Bo Brunsgaard | last post by:
I have a problem trying to run SQL*Loader after migrating to Oracle 9. It used to run with no hicups on Oracle 8i, and I'm at my wits' end. Any help? I'm trying to run SQL*Loader from a command...
6
by: Hari Om | last post by:
Here are the details of my error log files: I execute the command and get following message at console: ---------------------------------------------------------------------- ../sqlldr...
0
by: stef | last post by:
Hi, I have a range partitioned (one partition = one month) table. On this table I have a local unique index and a local domain index (Oracle Text) on a CLOB column. I'm running Oracle...
0
by: Thomas R. Hummel | last post by:
Hello, I am currently in the process of converting an Oracle data warehouse over to SQL Server. The warehouse is loaded through a bunch of text files all through SQL Loader, using various...
1
by: gkata | last post by:
I have a file that originated on the mainframe that contains both text and packed fields. I'm using sql loader to load a Oracle table, but I'm having difficulty with the packed fields loading...
5
by: vshalpatel | last post by:
Hi I want to use SQL*Loader , an Oracle-supplied utility to load data from a flat file into one database tables. for this I have write the scripts in the SQL*LOADER control file named ...
1
by: jith87 | last post by:
hi, i am importing a text file into oracle database using sql loader.i need to ommit the first and last records of the text file while importing... can anybody help???? this is my text file... ...
3
by: Tomo | last post by:
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...
4
by: E11esar | last post by:
Hello there. I'm having several issues with regards to loading data into an Oracle database. I am developing in ASP.Net with C# and the source data is in a CSV file. What I am looking for is to...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.