We recently updated our Oracle 10g R2 environment to 11g R2 (188.8.131.52), since the upgrade, the following UPDATE statement has been producing the above error:
update /*+ bypass_ujvc */
select s.mm_locationid, s.actualdate, s.time_sk, s.avg_drive_time,s.orders_per_dispatch, s.widgets, s.starters,s.avg_spend, a.drive_time_avg, a.orders_per_dispatch_avg, a.spend_avg, a.widgets_avg, a.starters_avg
from Del_2014_Labour_Scheduling_app s,del_2014_lab_sch_avg_hours a
where s.mm_locationid=a.mm_locationid and s.actualdate=a.actualdate
and s.time_sk between a.time_sk_min and a.time_sk_max
SET t.avg_drive_time = t.drive_time_avg,
I suspect it's the "/*+ bypass_ujvc */" query hint that's causing the issue. Could someone recommend a workaround? The two tables in question currently do not have primary key columns associated, a primary key column has since been created on the base table but the error persists.