Unable To Replicate Create Table DDL With Foreign Key Reference Using TimesTen Active Standby Pair Replication
(Doc ID 1603568.1)
Last updated on AUGUST 23, 2021
Applies to:Oracle TimesTen In-Memory Database - Version 11.2.1 and later
Information in this document applies to any platform.
When attempting to replicate CREATE TABLE DDL With A Foreign Key Reference there is one of two outcomes:
- If the ON DELETE CASCADE clause is not used, the table will be created on the Active but, not the Standby
- If the ON DELETE CASCADE clause is used, error 3017 will be observed
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!