Shulou(Shulou.com)06/01 Report--

Today, what the editor shares with you is the method of character set conversion between databases under different systems, which is not well understood by many people. Today, in order to give you a better understanding of the character set conversion between databases, the editor summarizes the following contents. Let's move on. I'm sure you'll get something.

The front-end computer Linux system imports the character set to the dmp backup of the similar database (Dameng database) of the server (Windows server2008 system) in the local local area network.

Here is the solution:

After using root to enter the Linux system, modify the character set format export LANG=zh_CN on the terminal operation command line

Go to the bin directory under the database installation directory: cd / opt/dmdbms/bin

Execute the export command: / opt/dmdbms/bin/dexp "SYSDBA" / "SYSDBA" @ IP:5236 DIRECTORY=/root/Desktop FILE=imp_exp.dmp TABLES= ("schema name". "table name") TABLESPACE=Y DROP=N LOG=exp_2016_10_24_09_28_02.log EXCLUDE= (INDEXES,CONSTRAINTS,TRIGGERS,GRANTS) LOG_WRITE=N

Import the exported files directly into the Windows system.

After reading the contents of the appeal, do you have a general understanding of the method of character set conversion between databases under different systems? If you want to know more, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.