TABLE DEFINITION CHECKING changes to exact after ttmigrate from 11.2.1 to 11.2.2

(Doc ID 2309718.1)

Last updated on NOVEMBER 21, 2017

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.8.20 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms