Page 1 of 1

CTable comparaison failed with Reason: ORA-02248

Posted: Mon 28 Jul 2014 19:35
Hi,

I'm trying to make a comparaison with Data compare for Oracle (just 1 table)
At the end of the process I get ORA-02248 Invalid alter session.

We're on Orale 11.2.0.3

Thanks

Regards

Cyrille

Re: CTable comparaison failed with Reason: ORA-02248

Posted: Wed 30 Jul 2014 09:29
by alexa
You need to perform the following the following:

1. For NLS_LANG on the client, please specify the same value as it set on the server. In System Properties, please make the Windows environment variable NLS_LANG = FRENCH_CANADA.WE8ISO8859P15

Also, on the client, please change the value of the NLS_LANG parameter in the registry.

Please see the article http://docs.oracle.com/cd/B19306_01/ins ... blsupp.htm saying:

"The NLS_LANG parameter is stored in the registry under the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID\NLS_LANG subkey, where ID is the unique number identifying the Oracle home."

2. Restart dbForge and perform comparison once again.