Shulou(Shulou.com)05/31 Report--

This article introduces how to solve the problem of inconsistent character sets in the process of Oracle expdp/impdp data migration, the content is very detailed, interested friends can refer to, hope to be helpful to you.

Premise:

Source-side character set: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Target character set: AMERICAN _ AMERICA. AL32UTF8

1. Query source and destination character set types: select userenv ('language') from dual

two。 Modify the target character set:

3. Shutdown immediate

4. STARTUP MOUNT

5. ALTER SYSTEM ENABLE RESTRICTED SESSION

6. ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0

7. ALTER SYSTEM SET AQ_TM_PROCESSES=0

8. ALTER DATABASE OPEN

9. ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK

10. Alter system set NLS_LANGUAGE='SIMPLIFIED CHINESE' scope=spfile

11. Alter system set NLS_TERRITORY='CHINA' scope=spfile

12. Shutdown immediate

13. Startup

14. If you look at it again, you can see that the character set is consistent with the source character set.

15. Upload the exported DMP file to the / home/oracle directory of Linux

16. Enter the database and create an impdp path: create directory expdir as'/ home/oracle'

17. Give system users the right to read and write the path: grant read,write on directory expdir to system

18. Perform impdp operation: impdp system/* directory=expdir dumpfile=$exp.dmp full=y logfile=$imp.log

On how to solve the problem of inconsistent character sets in the process of Oracle expdp/impdp data migration is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.