title: updating partition Key, row movement not allowed
body: <p>i want to update a partition key. the partition is as below</p>
  
  <pre><code>PARTITION_NAME  LAST_ANALYZED   NUM_ROWS    BLOCKS  SAMPLE_SIZE HIGH_VALUE
  PORTAL_SERVICE_1    12/8/2016   4133    174 4133    1
  PORTAL_SERVICE_2    6/8/2016    4474    174 4474    2
  PORTAL_SERVICE_3    10/8/2016   29602   2014    29602   3
  PORTAL_SERVICE_OTHERS   24/5/2016   0   110     DEFAULT
  </code></pre>
  
  <p>this partition is applied on column Portal_Service_id. i want to update the value of  portal service id from 2 to 1.</p>
  
  <p>when i try </p>
  
  <pre><code>update trans set PORTAL_SERVICE_ID = 1 where ID = 2054;
  </code></pre>
  
  <p>i get error: 
  Error report -
  SQL Error: ORA-14402: updating partition key column would cause a partition change
  14402. 00000 -  "updating partition key column would cause a partition change"</p>
  
  <p>i am not allowed to use Enable Row Movement.</p>
  
  <p>Can anybody please suggest any alternative to update the row.</p>
  
  <p>can anybody shed some light if this can be used in the scenario:</p>
  
  <pre><code>UPDATE &lt;table_name&gt; PARTITION (&lt;partition_name&gt;)
  SET &lt;column_name&gt; = &lt;value&gt;
  WHERE &lt;column_name&gt; &lt;condition&gt; &lt;value&gt;;
  </code></pre>