Re: SQL-Loader fine on 8.1, but not on 8.0.6

On Fri, 24 May 2002 17:07:40 +0200, "Thomas Stuefer" <stuefer_at_halli-data.at> wrote:

>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
>
>
8.0.6 is desupported for almost a year

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri May 24 2002 - 18:56:47 CEST