title: insert data from a table to another table sorted by column
body: <p>There is a temp table <code>TMP_OA_PSTN_CMP_11035</code> with fields:</p>
  
  <pre><code>ACTION_OBJID NUMBER,
  CONTRACT_OBJID NUMBER,
  STATUS varchar2(40),
  UPDATE_DATE DATE
  </code></pre>
  
  <p>This contains 7 million data.i want to create seven different temp tables with data from TMP_OA_PSTN_CMP_11035 sorted by action_objid and each containing  1 million records. <strong>The column ACTION_OBJID is not a sequence .</strong></p>
  
  <p>I tried using rownum but that inputs random  data.</p>
  
  <p>For EG:</p>
  
  <p>Temp1 : data containing action_objid from 5 ,8...to 1100000(as action_objid is not a sequence,this much is 1 million data).
  Similarly, for other 6 temp tables.
  I am using oracle 10g.</p>