TABLE DEFINITION CHECKING changes to exact after ttmigrate from 11.2.1 to 11.2.2 (Doc ID 2309718.1)

Last updated on APRIL 14, 2022

Applies to:

Goal

Give an explanation on why TABLE DEFINITION CHECKING is exact after ttmigrate from 11.2.1 to 11.2.2.

Symptom:

ttmigrate -c from 11.2.1

ttmigrate -r to 11.2.2

In 11.2.1, the definition is like following:

CREATE ACTIVE STANDBY PAIR rep1, rep2
SUBSCRIBER rep3
STORE rep1 PORT 21000 TIMEOUT 30
STORE rep2 PORT 22000 TIMEOUT 30;

After ttmigrate to 11.2.2, definition changes to:

CREATE ACTIVE STANDBY PAIR rep1, rep2
SUBSCRIBER rep3
STORE rep1 PORT 21000 TIMEOUT 30
table definition checking exact
STORE rep2 PORT 22000 TIMEOUT 30
table definition checking exact;

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.