Getting "ORA-00933: SQL command not properly ended" when dataType clause used in create sequence command
(Doc ID 2782967.1)
Last updated on APRIL 17, 2023
Oracle Database - Enterprise Edition - Version 22.214.171.124 and later Information in this document applies to any platform.
ORA-00933 error raised when CREATE SEQUENCE with dataType clause as below:
CREATE SEQUENCE test_seqAS BIGINTSTART WITH 1000INCREMENT BY 1NOCACHENOCYCLE;AS BIGINT*ERROR at line 2:ORA-00933: SQL command not properly ended
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!