Skip to content
April 8, 2011 / doganay

ORA-14402: updating partition key column would cause a partition change

Problem:

SQL> update table1 set col1=col1+1000;
update table1 set col1=col1+1000
*
ERROR at line 1:
ORA-14402: updating partition key column would cause a partition change


Cause:

You want to update a record and new value will belong to a different partition.


Solution:

Block must be physically re-located. You can not do this if row movement is not enabled:
1)

SQL> alter table table1 enable row movement;

if it is not ok,
2) delete record, insert record, commit.

Advertisements

3 Comments

Leave a Comment
  1. Barkha Deb / May 10 2011 6:10 am

    I encounter ORA-14402 when i do an alter table add column on a partitioned table. When I enable row movement on this table, I get an ORA-14406 error.

    I searched for the solution, but i am not clear what it is.

    thanks,
    Barkha

    • doganay / May 10 2011 6:14 am

      Hi Barkha,
      You must add another partition that capable to accept that key.

  2. bandhot / Jul 18 2012 4:31 am

    thx boiii it’s work

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: