-
import
1. I am using Oracle 8.1.7.4 64 bit version.
2. I am trying to perform an import a schema into a database which was created using UTF8 Characterset
3. The export file database was created with WE8ISO8859P1
During the import activity, i got an error as following:
Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
IMP-00016: required character set conversion (type 31 to 871) not supported
IMP-00000: Import terminated unsuccessfully
How to fix this error?
-
The export environment charachter set must match the import environment set. So, set your NLS_LANG to UTF8, re-do the export and try it again.
MH
-
Hey I got the solution
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
execute above command before import.