title: Oracle: updating data in referenced partition scenario is taking longer time
body: <p>I have table partitioned on a column(rcrd_expry_ts) of date type. We are updating this rcrd_expry_ts weekly by another job. We noticed the update query is taking quite longer time (1 to 1.5 min) even for few rows and I think longer time is taken for actually moving data internally to different partitioned. There can be a million of rows eligible to update rcrd_expry_ts by our weekly job.</p>
  <pre><code> CREATE TABLE tbl_parent 
  (   
     &quot;parentId&quot; NUMBER NOT NULL ENABLE, 
      &quot;RCRD_DLT_TSTP&quot; timestamp default timestamp '9999-01-01 00:00:00' NOT NULL
  )
  PARTITION BY RANGE (&quot;RCRD_DLT_TSTP&quot;) INTERVAL (NUMTOYMINTERVAL('1','MONTH'))  (PARTITION &quot;P1&quot;  VALUES LESS THAN (TO_DATE('2010-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')));
  
   CREATE TABLE tbl_child 
   (
     &quot;foreign_id&quot; NUMBER NOT NULL ENABLE,
     &quot;id&quot; NUMBER NOT NULL ENABLE, 
     constraint fk_id foreign key(&quot;foreign_id&quot;) references 
     tbl_parent(&quot;parentId&quot;)
   )partition by reference (fk_id);
  </code></pre>
  <p>I am updating RCRD_DLT_TSTP in parent table from some another job (using simple update query) but I noticed that it took around 1 to 1.5 min to execute, probably due to creating partition and move data into corresponding partition. Is there any better way to achieve this in Oracle</p>