1. Start with the Linux environment database of 12 c exp export data, export base character set is ZHS16GBK
2. Then use IMP under Windows system with IMP imported into the Windows version of the 12 c database
The following appeared in the process of the imported tip
12 c connect to: the Oracle Database Enterprise Edition Release 12.2.0.1.0-64 - bit Production
Through regular path by EXPORT: V12.02.00 create the EXPORT file
Has been completed ZHS16GBK character sets and AL16UTF16 NCHAR import
in a character setExport the client use US7ASCII character set (possible character set conversion)
IMP - 00403
Warning: this import generates a single SQL file "D: \ \ Administrator \ app kcdir \ imp_uop_sys SQL", which contains the failed due to access problems of the DDL,
Using imp import inspection, found that after the view and comment in Chinese are garbled, table table data is normal, this situation where I am going to set up to solve this problem?
Add:
DMP file specified character set is 0345, the second and third bytes corresponding ZHS16GBK
Import and export of the database character set: SIMPLIFIED CHINESE_CHINA. ZHS16GBK
CodePudding user response:
Using imp/exp export import, if encounter in the table is normal, but comments gibberish, basically all is set on both sides of the character set,For example:
Under the Linux environment in the source server export
Export NLS_LANG=SIMPIFIED CHINESE_CHINA. ZHS16GBK
On the target server to import, also want to set the environment variable, and to agree,
CodePudding user response:
On both sides of character set environment variables caused by inconsistent