title: How to reset IDENTITY column in oracle to a new value
body: <p>I am using <code>IDENTITY</code> feature of oracle 12 c to increment record id of a table. <br>As part of initial setup we have to migrate some records from another system to this table.  these records are non sequential records(Partial records are deleted). </p>
  
  <p>How to make identity to always create highest <code>value + 1</code> based on the table records. </p>
  
  <p>After googling for different options found keyword of <code>RESTART WITH</code> value option.  For this we need to create a new store procedure and alter all the tables with highest possible values to restart with. </p>
  
  <p>Is there any direct keyword which can be used along with <code>IDENTITY</code> which can force it to always regenerate higher values. ?</p>