-
Charecter set problem
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)
Anuj
India
-
Charater Set
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!!
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|