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_at_posting.google.com>
I want to export/import a DB from PC1 to PC2
SQL> select * from nls_database_parameters;
Date: 5 May 2004 00:23:12 -0700
Message-ID: <da07e661.0405042323.568fe7bd_at_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 - 09:23:12 CEST