Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.misc -> Re: problems loading multilingual data using SQL*Loader with External Tables ...

Re: problems loading multilingual data using SQL*Loader with External Tables ...

From: Frank van Bortel <>
Date: Thu, 28 Apr 2005 12:22:25 +0200
Message-ID: <d4qd9l$dkp$>

Giovanni Azua wrote:
> Hello,
> (Oracle 9i patchset level on Windows XP)
> I have been trying to insert hebrew data through Oracle SQL*Loader
> using External Tables and all records get discarded as bad even though
> the data delimiters and definition match exactly the external table
> definition (which works fine in production with english/european-based
> languages). One of the external tables that get all data discarded by

Giving the actual reason for rejection, perhaps *with* error codes would mke your fingertips wear, wouldn't it?

> Since there was no way to make it work with an instance configured with
> the default character set WE8MSWIN1252 I have tried doing the following:

Well, since when does the Windows codepage 1252 support hebrew?

> - Installed the Hebrew locale settings into my Windows XP.
> - Installed a new Oracle instance with character set unicode "AL32UTF8"
> specified the following registry: nls_language=HEBREW
> nls_territory=ISRAEL
> - Converted my external files to unicode UTF-8 using conversion option
> from UltraEdit v11.x

That probably is not needed - if you could see the hebrew text correctly, all would be OK.
Internally, Windows uses UTF.

> Tried executing the loading process and again got all my records discarded
> as bad. Looked into the alert_XXX.log and tracing files and no information
> about it ...

You specify the log file with the definition of the external table, and it's not the alert log file.

> Has anyone being through this same problem before? does anyone know
> how to recover error messages provided from failing records when using
> SQL*Loader?

Like I said - it's in your external table definition: create table ... ( ,,, )
organization external
( type oracle_loader
logile... )

You have NOLOGFILE...
And.. out of curiousity: does the BADFILE work the way you defined it?

Frank van Bortel
Received on Thu Apr 28 2005 - 05:22:25 CDT

Original text of this message