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
CTable comparaison failed with Reason: ORA-02248
-
- Posts: 1
- Joined: Mon 28 Jul 2014 19:10
Re: CTable comparaison failed with Reason: ORA-02248
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.
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.