Error in update activity

[francisc4181303]

Hi,  I'm using a enrichment activity to add data then doing a deduplication the data then trying to update data activity.  In the Update activity I’m getting the following error and i can't figure it out any help would be greatly appreciated

Oracle error: 'ORA-01779: cannot modify a column which maps to a non key-preserved table'

[florentlb · Accepted solution]

Hi,

From my understanding key-preserved tables are specific to Oracle database. Is the table you are trying to update in this case? Do you have a way to change this at the database level?

Campaign won't be able to update data on such tables.

Let me know,

Florent.