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.