| error on exp/imp database [message #54122] |
Wed, 30 October 2002 17:48  |
Jasmine
Messages: 23
Registered: December 2000
|
Junior Member |
|
|
Hi, All
there have two oracle in our company. the older one is 8.1.5, on solaris; the newer one is 9.0.1, on win2000server.
now we want to migrate all tables and views and data from the old one to the new one.
using exp utility, we got a file. then we moved the file to 2000, and using imp. but got an error message:
imp-00016 required character set conversion (type 850 to 852) not supported
SQL > col value$ format a40
SQL > select name,value$ from props$;
using this command on both machine, we found the only different set between them is "NLS_NCHAR_CHARACTERSET"
the old one is "US7ASCII" and new one is"AL16UTF16"
why? how to modify them?
thanx a lot
|
|
|
|
| Re: error on exp/imp database [message #54125 is a reply to message #54122] |
Wed, 30 October 2002 23:20  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
When importing into the new database instance, set NLS_LANG to the value of the old database (the export source), not to the real target db character set.
In your case that would be:
on the new db with CS=AL16UTF16 setup the old CS an ddo the import.
C:>set nls_lang=american_america.usascii
C:>imp parfile=
The import utility will handle the CS conversion internaly. You have to make sure that all data columns have enough free space to handle the extra bites which you will get from the conversion. You can do that by using the Character Set Scanner
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
