Database import between Oracle817 versions of different character sets

oracle| Data | database
Database import between Oracle817 versions of different character sets



For business reasons, it is necessary to import an English character set (AMERICAN_AMERICA.WE8ISO8859P1) database dmp file into a Chinese character set (simplified Chinese_china. ZHS16GBK) in the database. Because of the different character set, the database environment of Chinese character set needs to be changed into English character set. Encountered a lot of trouble, through the Internet to find information, finally solved the problem. In this process, found that netizens have the same problem, in order to let everyone in the future can successfully complete this kind of work, now will I import the success of the process written out to share with you.



First, the system environment:



Export environment:



Host: Compaq minicomputer

Operating system: Unix

Database: oracle8.1.7{English character set (AMERICAN_AMERICA.WE8ISO8859P1)}



Import Environment:



Main machine: Ordinary PC

Frequency: PIII750

Memory: 192M

Operating system: Windows server

Database: Oracle8.1.7 Chinese Character set (simplified Chinese_china). ZHS16GBK)



Note: The export process omits



Second, the import process



1, will Win2000 system in the Oracle registry



[Nls_lang] key value in [HKEY_LOCAL_MACHINE Oftware\oracle]

"Simplified Chinese_china. ZHS16GBK "changed into

"American_america.we8iso8859p1"



2, with the system user's identity, under the Sql-plus execute the following statement:



Update sys.props$ set value$= ' we8iso8859p1 ' where name= ' nls_characterset ';



Update sys.props$ set value$= ' we8iso8859p1 ' where name= ' nls_nchar_characterset ';



Commit



3. Restart Oracle



4. Start importing Database



UserID = user name/password @ link string

Buffer = 60000

Log = C:\dmp.log

FILE = C:\ Import data file name. DMP

Fromuser = user Name

Touser = user Name



Note here to make sure that the imported table space and the user have been established and exported to the file, and that the user has DBA authority, or it may affect the integrity of the imported data.



5, check the import effect, in the current environment, test data is correct, whether there is garbled, whether there are not successfully imported tables and other triggers, procedures and functions and other information. After confirming that the import is not a problem, go to the next step.

6, the Win2000 under the Oracle character set environment into Chinese character set.

[Nls_lang] key value in [HKEY_LOCAL_MACHINE Oftware\oracle]

"AMERICAN_AMERICA.WE8ISO8859P1" changed back to

"Simplified Chinese_china. ZHS16GBK "

7, with the system user's identity, under the Sql-plus execute the following statement:



Update sys.props$ set value$= ' ZHS16GBK ' where name= ' nls_characterset ';



Update sys.props$ set value$= ' ZHS16GBK ' where name= ' nls_nchar_characterset ';



Commit



8, restart the database.



Check the data in your database, if there is no garbled, and your program can operate in this environment, then congratulations, you also succeeded!!



Above is the whole process that I import, if have a mistake place, also hope everybody is pointing, you can get in touch with me through email:hawk_flying@sina.com.