SQL-Loader fine on 8.1, but not on 8.0.6
Date: Fri, 24 May 2002 17:07:40 +0200
Message-ID: <eGsH8.2$yU7.97376_at_news.salzburg-online.at>
[Quoted] I will load data with the following control-file:
LOAD DATA
INFILE 'kostenst.dat' "STR X'7C0D0A'"
APPEND INTO TABLE kostenstelle
FIELDS TERMINATED BY WHITESPACE OPTIONALLY ENCLOSED BY "'"
(nr,bez)
The data looks like:
'100' 'Aviation-Leistungen'|
'101' 'Verkehrsmanagement'|
'102' 'Leiter Aviaton/Sekret.'|
'105' 'Verkehrs/Flugl"rmanalyse'|
'106' 'Flugverk.plg u. Statistik'|
'110' 'Marketing u. Werbung'|
'111' 'Marketing'|
'112' 'Werbung'|
With Oracle 8.1.7.2.7 it work's fine, but with 8.0.6 the SQL-Loader hangs without displaying an error and without importing any record (both on Win 2000).
Remark: The stream "STR X'7C0D0A'" is because the data himself can contain CR+LF, so I generated as distinction at the end of each record Pipe+CR+LF.
Many thanks for your help !
Tom Received on Fri May 24 2002 - 17:07:40 CEST