Update Partition Table fields in Oracle

An error is reported when updating table partition fields, because partitions generally specify different tablespaces. When updating a field's exaggerated Partition Rules, you must:

Alter table ** enable row movement;

In this way, you can update it.

You can also insert an identical record to the database first (if the primary key is repeated, you can change the value of the primary key field of the data first) at the same time, remember to assign a value to the field value to be changed before inserting, delete the original record, and update the field value of the primary key that has just been modified.

In fact, the process in method 1 is similar to that in method 2, but the operation on rowid is complicated.