title: rename sequence in other schema with same currval
body: <p>I need to rename bunch of sequences in another schema.</p>
  
  <p>RENAME old_seq to new_seq doesnt work.</p>
  
  <p>Tried:</p>
  
  <pre><code>ALTER SEQUENCE old_seq RENAME TO new_seq;
  </code></pre>
  
  <p>but it gives me error </p>
  
  <pre><code>ORA-02286: no options specified for ALTER SEQUENCE 
  </code></pre>
  
  <p>I do not wish to mention all the options that i had mentioned earlier while creating the sequence, since they need to be same. Only the name needs to be changed.</p>