I want to export/import a DB from PC1 to PC2
PC 1:
-----
SQL> select * from nls_database_parameters;
PARAMETER VALUE
NLS_CHARACTERSET WE8ISO8859P1
PC 2: NLS_LANG=AMERICAN_AMERICA.UTF8
-----
An error occurs when importing the dump file:
IMP-00016: required character set conversion (type 31 to 871) not supported
I tried converting the character set at PC1:
ALTER DATABASE CHARACTER AMERICAN_AMERICA.UTF8;
ORA-12712: new character set must be a superset of old character set
What to do?
Is there a way to do the conversion anyway? (ie. when exporting ?)
Changing the settings at PC2 to accept the character set of PC1 ?