oracle字符集转换工具DMU使用

简介: 关于oracle字符集的介绍参考:http://blog.csdn.net/cymm_liu/article/details/7605081 (此博客也包含了一种修改字符集的方法,但是不建议使用) 今天我们为了解决这个问题:http://blog.csdn.net/cymm_liu/article/details/12013243 采用oracle 的字符集转换工具DMU来进行操作。

关于oracle字符集的介绍参考:http://blog.csdn.net/cymm_liu/article/details/7605081 (此博客也包含了一种修改字符集的方法,但是不建议使用)

今天我们为了解决这个问题:http://blog.csdn.net/cymm_liu/article/details/12013243

采用oracle 的字符集转换工具DMU来进行操作。。

1、DMU简介

参考:The Database Migration Assistant for Unicode (DMU) Tool (文档 ID 1272374.1)

Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration tool providing an end-to-end solution for migrating your databases from legacy encodings to Unicode. DMU's intuitive user-interface greatly simplifies the migration process and lessens the need for character set migration expertise by guiding the DBA through the entire migration process as well as automating many of the migration tasks. It comes with a scalable in-place migration architecture which significantly reduces the effort and downtime required for data conversion, comparing to conventional export and import migration methods. For post-migration and existing databases already using the Unicode character set, the DMU also has a validation mode, in which it identifies data not correctly encoded in Unicode, thus providing a healthcheck on potential issues with implementation of Unicode in database applications.

New! Oracle DMU 1.2, released in February 2013, supports the new VARCHAR2 data type length limit that has been extended in Oracle Database 12c to 32767 bytes. VARCHAR2 data up to 8191 bytes can now be migrated to Unicode with guarantee to not expand over the limit. As 8191 bytes is more than the original limit of 4000 bytes, all databases freshly upgraded to Oracle Database 12c can be migrated to Unicode with significantly simplified handling of data length expansion issues. Other new features in DMU 1.2 include the support for 64-bit JDK on Windows, a new script CSREPAIR for fixing incorrect database character set declarations, and a Live Update feature to automatically check for future DMU updates and upgrade the existing installation transparently. This release of the DMU is also bundled with Oracle Database 12c in addition to being distributed via OTN. The legacy character set migration utilities CSSCAN and CSALTER are no longer shipped or supported with Oracle Database 12c. Please see the DMU 1.2 Release Notes for changes since the 1.1 release.

Oracle DMU is described in more details in the DMU Data Sheet.


使用步骤:

参考:

http://www.oracle.com/technetwork/products/globalization/dmu/learnmore/start-334681.html









相关文章
|
存储 Oracle 关系型数据库
|
Oracle 关系型数据库 数据库
修改oracle字符集
一 修改数据库SERVER端字符集    数据库字符集在创建后原则上不能更改。如果需要修改字符集,通常需要导出数据库数据,重建数据库,再导入数据库数据的方式来转换,或通过ALTER DATABASE CHARACTER SET语句修改字符集,但创建数据库后修改字符集是有限制的,只有新的字符集是当前字符集的超集时才能修改数据库字符集,例如UTF8是US7ASCII的超集,修改数据库字符集可使用ALTER DATABASE CHARACTER SET UTF8。
1018 0
|
SQL 存储 Oracle
oracle 字符集查看与修改
一、什么是Oracle字符集        Oracle字符集是一个字节数据的解释的符号集合,有大小之分,有相互的包容关系。ORACLE 支持国家语言的体系结构允许你使用本地化语言来存储,处理,检索数据。
1311 0
|
Oracle 关系型数据库 PostgreSQL
|
Oracle 关系型数据库 测试技术
oracle字符集修改
1,一般默认情况下oracle安装完后,字符集不支持中文,插入中文则会乱码   查看当前数据库的字符集语言,再次测试插入中文语言,验证是否乱码
614 0
|
SQL 存储 Oracle
oracle字符集查看修改
一、什么是Oracle字符集        Oracle字符集是一个字节数据的解释的符号集合,有大小之分,有相互的包容关系。ORACLE 支持国家语言的体系结构允许你使用本地化语言来存储,处理,检索数据。
911 0

推荐镜像

更多