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 ...
Giovanni Azua wrote:
> Hello,
>
> (Oracle 9i patchset level 9.2.0.5 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?
-- Regards, Frank van BortelReceived on Thu Apr 28 2005 - 05:22:25 CDT