> have a situation, need to increase a column width, which is also a partition key and table is pretty huge, can any one assist, what is the best possible way to achieve this task. > you will need to rebuild the table. you cannot modify the partition key of the existing table.. I have a partition table which is partition on date_loaded column, can i alter the partition key column to orig_date_loaded column thanks. i'm able to rename partitioned tables partition key column. oracle database 11g enterprise edition release 11.2.0.3.0 - 64bit pl/sql release 11.2.0.3.0.. Oracle database 12c administrator certified professional exam; ocm. server configuration; enterprise manager grid control; ora-14402: updating partition key column would cause a partition change. sql> alter table partition_test enable row movement; table altered. sql> update partition_test set key=key+100; 1 row updated..
The partitioning key is comprised of one or more columns that determine the partition where each row will be stored. oracle automatically directs insert, update, and delete operations to the appropriate partition through the use of the partitioning key.. Updating partition key, row movement not allowed. updating partition key column would cause a partition change 14402. 00000 - "updating partition key column would cause a partition change" i am not allowed to use enable row movement. why do you have the mysql tag on an oracle question. – barmar aug 16 '16 at 2:33.. To split a materialized interval partition, you specify a value of the partitioning key column within the interval partition at which to split the partition. the first of the resulting two new partitions includes all rows in the original partition whose partitioning key column values map lower than the specified value..
