TimesTen Error Messages

TT-03017

Child table table_name in a foreign key relationship with ON DELETE CASCADE must be replicated if its parent table table_name is replicated


Cause

When a primary key table is included in a replication scheme, its corresponding foreign key table must be included in the replication scheme, as well. This error is returned when an ON DELETE CASCADE operation is attempted on a foreign key table in a replication scheme, but the primary key table is not included 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.