TimesTen Error Messages

TT-03018

Child table table_name in a foreign key relationship must be replicated if its parent table table_name is replicated


Cause

A foreign key table in a primary key/foreign key relationship is not being replicated. Make sure both or neither of the tables is in the replication scheme.


Action

Ensure that if a child table with a foreign key defines ON DELETE CASCADE, then you must replicate any other table with a foreign key relationship to the child table. See Replicating Tables with Foreign Key Relationships in an Active Standby Pair in Oracle TimesTen In-Memory Database Replication Guide.


Additional Information

This requirement prevents foreign key conflicts from occurring on the standby master tables when a cascade deletion occurs on the active master database.