ITPub博客

首页 > 数据库 > 数据库开发技术 > 关于goldengate 对源表和目的表的表结构一致的定义

关于goldengate 对源表和目的表的表结构一致的定义

原创 数据库开发技术 作者:msdnchina 时间:2011-05-27 23:17:55 0 删除 编辑

以下摘自goldengate v11.1.1 reference 第324页:

Using COLMAP
Use COLMAP to explicitly map source columns to target columns that have different names
or to specify default column mapping when source and target names are identical. COLMAP
provides instructions for selecting, translating, and moving column data. Do not use this
option for tables being processed in pass-through mode by a data-pump Extract group.

NOTE To create global rules for column mapping across all tables in subsequent TABLE
statements, use the COLMATCH parameter.

Generating data definitions
When using COLMAP for source and target tables that are not identical in structure, you
must generate data definitions for the source tables, transfer them to the target, and use
the SOURCEDEFS parameter to identify the definitions file.


For source and target structures to be considered identical, they must contain identical
column names (including case, if applicable) and data types, and the columns must be in
the same order in each table. In addition, both tables must have the same column length
semantics for character columns (bytes versus characters)
.
If the tables have identical structures, and you are using COLMAP for other functions such
as conversion, a source definitions file is not needed. You can use the ASSUMETARGETDEFS
parameter instead.
For more information, see:
● SOURCEDEFS on page 306
● ASSUMETARGETDEFS on page 117
● “Creating a data-Definitions file” in the Oracle GoldenGate Windows and UNIX
Administrator’s Guide.

[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/161195/viewspace-1050457/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-07-30

  • 博文量
    498
  • 访问量
    1542056