SQL*Loader concatenation failure with 8.1.7

SQL*Loader concatenation failure with 8.1.7

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'Daniel Vorster' on July 13, 2001 at 09:13:21 EST:

We recently upgraded to 8.1.7 and sqlldr scripts started failing. They worked ok with previous version of Orace. The problem is related to the CONCATENATE keyword. Previously it seems that Oracle inserted a white space (space or some other delimiter) between the lines that it concatenated. Now, it does not, so fields which are terminated by a newline on concatenated lines do not import correctly - sqlldr cannot find the field delimiter. We can fix the problem by manipulating the data file (essentially adding some terminator to the end of each line), but if there is a way to fix it with the ctl file I would prefer that.

Any ideas?

Thanks,
Daniel

Follow Ups:

Post a Followup

Name:
E-Mail:
Subject:
Message: : Hi : We recently upgraded to 8.1.7 and sqlldr scripts started failing. They worked ok with previous version of Orace. The problem is related to the CONCATENATE keyword. Previously it seems that Oracle inserted a white space (space or some other delimiter) between the lines that it concatenated. Now, it does not, so fields which are terminated by a newline on concatenated lines do not import correctly - sqlldr cannot find the field delimiter. We can fix the problem by manipulating the data file (essentially adding some terminator to the end of each line), but if there is a way to fix it with the ctl file I would prefer that. : Any ideas? : Thanks, : Daniel