DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Dec 2005
    Posts
    195

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

    All,

    I am updating the table based on the leading partition key and i got the error message.

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

    Again i changed the table as below.

    alter table inventory ENABLE ROW MOVEMENT;

    Now it works fine. I have two questions.

    1. When we update the partition key, does oracle really move the data to different partition or it deletes the record in current partition and insert into another partition?.

    2. Is it overhead when we update parition key? Any extra cost?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    1. They are the same ... move = delete + insert

    2. Yes ... you're not just updating a single column and leaving the row in place, you're actually moving the row to a new block. You're also requiring that two partitions of every local index be modified
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Dec 2005
    Posts
    195
    Thank you for the answer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width