Re: SOLUTION: Sorting works incorretly on Client

I've found the solution:
The client is an english version Windows 2000 Prof with German regional settings. I changed the regional settings to English (USA) before installing the client and changed it back to German after installing and everything works fine!
Obviously Oracle installs German parts (even if you select English as product language) if regional settings are set to German.

Jakob

"Jakob Blomer" <jakob_at_blomer.de> wrote in message news:aimp6j$gq0$03$1_at_news.t-online.com...
> Hi,
> I've a problem with our Oracle 8i developer system: If I sort a table (ca.
> 60000 rows, indexed) on a Client mashine oracle sorts
> 1. Wrong order
> 2. It takes forever (about 15 seconds)
> I found a workaround only for the first problem: alter session set
> nls_sort=binary;
> I tried sorting on the server mashine and everything works fine. On the
> production system in our customer's company everything works fine on both,
> the client and the server.
> I checked the Net8 configuration and couldn't find anything bad
configured.
> The configuration is almost the same as on the server.
> We have an 100MBit switched network, all other network operations are ok.
>
> Thanks for any help or suggestions,
> Jakob
>
>
Received on Tue Aug 06 2002 - 10:52:03 CDT