| NLS_LANG settings [message #139511] |
Wed, 28 September 2005 07:34  |
mymot
Messages: 225
Registered: July 2005
|
Senior Member |
|
|
Hi,
Its gives problem only when tables were exported from 9.0.2 and imported in 10g and complaining about characterset
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION
IMP-00000: Import terminated unsuccessfully
so i was trying to do the following
I am trying to set
sql> ALTER SESSION SET NLS_CHARACTERSET = ENGLISH_'UNITED KINGDOM'..WE8MSWIN1252;
ALTER SESSION SET NLS_CHARACTERSET = ENGLISH_'UNITED KINGDOM'.WE8MSWIN1252
*
ERROR at line 1:
ORA-00922: missing or invalid option
Any suggestions?
Thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
