Database Error Messages

ORA-03826

Cannot include multiple replication units in a local transaction (transaction ID = transaction_id, chunk ID = chunk_id, RU 1 = replication_unit_1, RU 2 = replication_unit_2).
  • transaction_id: The local transaction ID.
  • chunk_id: The chunk ID mapped to the rejected replication unit.
  • replication_unit_1: The existing replication unit in the transaction.
  • replication_unit_2: The replication unit being added to the transaction.

Cause

A local transaction attempted to modify data that belongs to more than one sharding replication unit in the same shard.


Action

Rewrite the operation to modify only one replication unit in each local transaction, or execute the operation as a distributed transaction started from the shard catalog.