Updating Partition Key Column 1104

Меню

Search the Web:

Updating Partition Key Column 1104 на сайте oaeservice.ru



при попытке изменить дату документа (docdate) с переходом в другую патицию возникает ORA-14402: updating partition key column would cause a partition change. можно ли что-то сделать чтобы не удалять док. и создавать его заново ?

Oracle throws an error : ORA-14402 updating partition key column would cause a partition change. I think that this is because emp_det is a partitioning key of a partitioned table. Oracle documentation says that.

The SQL Exception is: "ORA-14402: updating partition key column would cause a partition change. Normally this error happens after making the partitions to the tables. Solution Description

How can I update a column which is the partition key? I got an error message saying that 'ORA-14402: updating partition key column would cause a partition change'? Note: DB2 version 7.2 provides updateable partitioning keys for data redistribution.

While updating a row in partitioned table, got below error. Solution: This error occurs, if we are trying to update a column( which is partitioned key), where the new value is outside the range of the existing partition, then it will fail.
Скриншот из видео : ORA-14402: updating partition key column would cause a partition...