| Want help on SQL*Loader [message #173211] |
Sat, 20 May 2006 05:05  |
bhupendra_fatnani
Messages: 1
Registered: May 2006
Location: Noida, India
|
Junior Member |
|
|
I am trying to load the data into the table allele using the following code :
LOAD DATA
INFILE "allele.txt"
APPEND
INTO TABLE ALLELE
FIELDS TERMINATED BY X'09'
(allele_id, allele, create_time, rev_allele_id, src, last_updated_time)
The delimiter in the file is a tab. Is the format correct to upload?
The upload generates the following errors :
Commit point reached : logical record count 42
commit point reached : logical record count 84
Can someone pls help me how to solve the above problem?
[Updated on: Sat, 20 May 2006 05:07] Report message to a moderator |
|
|
|
| Re: Want help on SQL*Loader [message #173217 is a reply to message #173211] |
Sat, 20 May 2006 05:39  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
X'09' is tab delimited.
| Quote: |
The upload generates the following errors :
Commit point reached : logical record count 42
commit point reached : logical record count 84
|
What makes you think that these are errors?
Did you check the log file?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
