Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Error in update activity

francisc4181303
Level 1
Level 1

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'
1 Accepted Solution
florentlb
Correct answer by
Level 10
Level 10

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.

View solution in original post

1 Reply
florentlb
Correct answer by
Level 10
Level 10

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.

View solution in original post