Charecter set problem

[anuj]

Export done at solaris server, I am trying to import in same version but in Windows 2000 server.

it is given charcter set problem. can i change charcter set, I an not able to find out NLS_charcterset parameter in init.ora file.

can anyone suggest

Import: Release 8.1.7.0.0 - Production on Thu Dec 19 20:41:00 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

Import file: EXPDAT.DMP > E:\Saco\algo.dmp

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
export server uses WE8ISO8859P15 NCHAR character set (possible ncharset conversi
on)

[mjrio33]

Anuj ,

The character set is initially set in the "Create Database" statement,before doing an export make sure your OS env variable for NLS_LANG, you can use the following script to find what character set is set for your database:

select 'export NLS_LANG="'||char_date.value||'_'
||char_iso_value.value||'.'
||char_char_value.value||'"'
from v$nls_parameters char_date,
(select value
from v$nls_parameters
where parameter='NLS_ISO_CURRENCY') char_iso_value,
(select value
from v$nls_parameters
where parameter = 'NLS_CHARACTERSET') char_char_value
where char_date.parameter = 'NLS_DATE_LANGUAGE';

ALSO NOTE: In order to change Character Set you have to RECREATE DB!!

[pando]

WE8ISO8859P15 is WE8ISO8859P1 but supports EURO sign, that´s just a warning, if you want to avoid it then set your NLS_LANG to WE8ISO8859P1