I have Oracle version 12.2.0.1.0
We have generic script which create sequence that need to be reuse for different objects (by renaming sequence name):
CREATE SEQUENCE NAME_SEQ MINVALUE 1 MAXVALUE 999999999
INCREMENT BY 1 START WITH 100 CACHE 200 NOORDER NOCYCLE NOPARTITION ;
This script isn't working with below error until I remove NOPARTITION :
ORA-00933: SQL command not properly ended
I found in AskTom that the NOPARTITION is not supported in 12.2
there's been various of things in previous versions of the database that are no longer relevant/supported
Why it's not supported and/or what is the replacement of this feature ?
If there's no replacement can you state why this feature shouldn't be used?
The (no)partition option for sequences was never documented. And thus never supported.
There was a bug in 12.1 which exposed this via dbms_metadata. It no longer happens in 12.2
Undocumented features can (and as this proves) do change without warning. Using them is strictly at your own risk.