Goldengate Replicat Ignores "Alter Table Rename" DDL [ID 1216846.1]
		修改时间 16-DEC-2010 类型 PROBLEM 状态 PUBLISHED

In this Document
Symptoms
Cause
Solution
References

---

Applies to:

Oracle GoldenGate - Version: 10.4.0.19 and later [Release: 10.4.0 and later ]
Information in this document applies to any platform.

Symptoms

Source: as user PRICERC1 - ALTER TABLE test RENAME TO bkup_test;

Target: replicat logs in as ggs, with parameter

DDL INCLUDE MAPPED OBJNAME "PRICERC1.*"
map PRICERC1.*, target PRICERC1.*;

The ddl is ignored by replicat as it is considered as excluded.

Cause

This is Bug 9857943.

Solution

Bug 9857943 is fixed in version 11.1.1.0.2 Build 002 and later.

There are also several Workarounds:

1. login as sysdba in replicat

2. login as PRICERC1 in replicat

3. change DDL parameter
from: DDL INCLUDE MAPPED OBJNAME "PRICERC1.*"
to : DDL INCLUDE MAPPED
note: this may included nother mapped DDLs.

4. change DDL parameter
from: DDL INCLUDE MAPPED OBJNAME "PRICERC1.*"
to : DDL INCLUDE MAPPED OBJNAME "PRICERC1.*" include OBJNAME "GGS.*"

5. change DDL parameter
from: DDL INCLUDE MAPPED OBJNAME "PRICERC1.*"
to : DDL INCLUDE MAPPED OBJNAME "PRICERC1.*" include string "RENAME"
note: this may include other RENAME DDLs from schemes other than PRICERC1.

References

BUG:9857943 - RENAME DDL IS IGNORED

相关的 产品 Middleware > Data Integration > GoldenGate > Oracle GoldenGate

[@more@]