Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!postnews1.google.com!not-for-mail From: plize@letsdothatagain.com (Caroline) Newsgroups: comp.databases.oracle Subject: copy a DB from PC1 to PC2 Date: 5 May 2004 00:23:12 -0700 Organization: http://groups.google.com Lines: 21 Message-ID: NNTP-Posting-Host: 62.84.65.10 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1083741792 14397 127.0.0.1 (5 May 2004 07:23:12 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 5 May 2004 07:23:12 +0000 (UTC) Xref: core-easynews comp.databases.oracle:27525 X-Received-Date: Wed, 05 May 2004 00:22:51 MST (news.easynews.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 ?