title: Difference in oracle 11.2.0.1.0 and oracle 11.2.0.2.0 while inserting a value into the table using sequence
body: <h2>In Oracle 11.2.0.1.0:</h2>
  
  <p>1) I created a table.</p>
  
  <p><code>create table m1(id number(5,2), version number(5,2), primary key (id));</code></p>
  
  <p>2) I created a sequence.</p>
  
  <p><code>CREATE SEQUENCE m1_id_sq;</code> </p>
  
  <p>3) I inserted values into the table.</p>
  
  <p><code>insert into m1(id, version) values (m1_id_sq.nextval, 1);</code></p>
  
  <p>4) output.</p>
  
  <p><code>id</code>  <code>version</code></p>
  
  <p><code>-------------</code></p>
  
  <p><code>2</code>         <code>1</code></p>
  
  <p>*I understand the reason for id=2 is due to deferred_segment_creation feature introduced from 11.2.0.1.0 onwards.</p>
  
  <p>*I created an user instance in oracle and I ran the above three commands. Not as a master. </p>
  
  <p>Now I follow the same steps </p>
  
  <h2>in Oracle 11.2.0.2.0,</h2>
  
  <p>but the output I got is,</p>
  
  <p><code>id</code>  <code>version</code></p>
  
  <p><code>-------------</code></p>
  
  <p><code>1</code>         <code>1</code></p>
  
  <p>Please explain why the id=1 in oracle 11.2.0.2.0 whereas id=2 in oracle 11.2.0.1.0. Great thanks! </p>