Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Strange sqlloader loader issue with carriage return in Unix

109137Apr 30 2010 — edited May 4 2010

Oracle 10g
Solaris

Hi All, I'm having issues in running some data into a table via sqlloader. The data was extracted using concatanated SQL with a | delimiter. sql script was executed in the shell to produce the data file.

eg
a,b,c|
d,e,f|

The control file specifies a string terminator as "str '|\n'" but when i run the sqlloadr command on the unix box I states that

no terminator found after TERMINATED and ENCLOSED field.

Ive tried it with \n\r same sort of issue.

The strange scneario i encountered was when I just specified "str '|'" as I read unix would default to \n, the weird thig was that my 6 records DID load into the table succesfully but a bad file was produced with a | character in it and the log file specfied that it tried to load 7 records where 6 were succesfull and 1 failed even though I only had 6 record to play with in the 1dst place.

Any ideas / thoughts greatly appreciated?!

Kind regards
Satnam