Re: Export Job fails because of different NLS_LANG

"Tom Jordan" <TomJordanTojo_at_hotmail.com> wrote in message news:MPG.15a181babb49148298968f_at_news.t-online.de...
> I am using OEM 2.2 and Oracle 8.1.7 on Windows NT
>
> The export job I scheduled is failing because of:
>
> EXP-00041: Export in UTF8 from Server differs from character set
> WE8ISO8859P1 from user
>
> The database I am exporting is indeed UTF8. The preffered credentials
> for the database are INTERNAL/PASSWORD AS SYSDBA. The job belongs to
> SYSMAN. The OEM repository is also in UTF8. Now, which user is logging
> into "exp", and how do I change its NLS_LANG setting? I even changed the
> NLS_LANG environment variable to UTF8 on the OEM machine, but no go.
>
> Why can't these things just work the first time? Message to exp: just do
> the conversion! Sorry, just venting there..
>
> Thanks.
>
>

You are running exp from the client not from the server. Hence NLS_LANG in the registry in hklm\software\oracle must be correct. Or just don't use a direct export.
How do you expect things to work when you don't configure it correctly? Issues like this are documented. Oracle is not a toy! Sorry, just being a bit annoyed about your final remarks.

Regards,

Sybrand Bakker, Oracle DBA Received on Sat Jul 21 2001 - 23:58:46 CEST