update of partition generates ora 14402, but no key column is being updated
526088Aug 2 2006 — edited Aug 2 2006update large_partitioned_table partition(cy2005)
set my_code = 'L'
where columnX = 'X'
and columnY = 'Y'
and columnZ = 'Z' ;
results in
ORA-14402: updating partition key column would cause a partition change
with the asterisk on the last line in the where clause. But this table is partitioned by range ( by date ) and
select * from dba_part_key_columns where name = 'LARGE_PARTITIONED_TABLE';
yields only a date field, which is not referenced in my query in any way.
This is on Oracle8i (8.1.7) on Tru64 (OSF1 v5.1)
As far as I can figure out, I should be able to specify a partition in an update statement, and if I am not referencing the partion key field, much less updating it, I don't understand why I am getting the 14402.
Any help in explaining this would be appreciated.