ORA-01407: Cannot Update ("SYS"."HIST_HEAD$"."COL#") To NULL

Last updated on JULY 13, 2017

Applies to:

Symptoms

You  added a new column to an existing partitioned table and also the temporary  table. Now when you  try to exchange a partition with the temporary table, you receive the following error:

ALTER TABLE  mytable EXCHANGE PARTITION part_1706 WITH TABLE temp WITH VALIDATION;

ORA-00604: error occurred at recursive SQL level 1
ORA-01407: cannot update ("SYS"."HIST_HEAD$"."COL#") to NULL

You have tried the workaround in note: EXCHANGE PARTITION Results In ORA-01407: Cannot Update ("SYS"."HIST_HEAD$"."COL#") To NULL (Doc ID 1677855.1) but you still get the error.

Changes

 You added new column(s) to both original and temp table.

Cause