title: Oracle 12.2 - Replacement of NOPARTITION feature
body: <p>I have Oracle version 12.2.0.1.0</p>
  <p>We have generic script which create sequence that need to be reuse for different objects (by renaming sequence name):</p>
  <pre><code>CREATE SEQUENCE NAME_SEQ MINVALUE 1 MAXVALUE 999999999
  INCREMENT BY 1 START WITH 100 CACHE 200 NOORDER  NOCYCLE  NOPARTITION ;
  </code></pre>
  <p>This script isn't working with below error until I remove <code>NOPARTITION</code> :</p>
  <pre><code>   ORA-00933: SQL command not properly ended
  </code></pre>
  <p>I found in AskTom that the <a href="https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9523071800346490539" rel="nofollow noreferrer">NOPARTITION is not supported in 12.2</a></p>
  <blockquote>
  <p>there's been various of things in previous versions of the database that are no longer relevant/supported</p>
  </blockquote>
  <p>Why it's not supported and/or what is the replacement of this feature ?</p>
  <p>If there's no replacement can you state why this feature shouldn't be used?</p>