copy a DB from PC1 to PC2

From: Caroline <plize_at_letsdothatagain.com>
Date: 5 May 2004 00:23:12 -0700
Message-ID: <da07e661.0405042323.568fe7bd@posting.google.com>

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 ? Received on Wed May 05 2004 - 02:23:12 CDT