469,089 Members | 1,205 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,089 developers. It's quick & easy.

copy a DB from PC1 to PC2

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 ?
Jul 19 '05 #1
1 3287
Caroline wrote:
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 ?


Be warned: you may loose data - the least you probably will
get is gibberish (malformed characters)
Having said that, I think the following should work:
export PC1, make sure your environment has WE8ISO8859P1
for characterset. Export log should mention the used set.
Import on PC2, making sure you have UTF8 set.

You want to import and export without any warnings
"Character conversion possible" in either of the
logs; that is neither the import log, nor the
export log.
In this manner you will not be facing any conversion.
--

Regards,
Frank van Bortel

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

42 posts views Thread by Edward Diener | last post: by
15 posts views Thread by A | last post: by
10 posts views Thread by utab | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.