database - 一个数据库中出现“SQL 命令未正确结束”错误，但另一个数据库却没有，使用相同的脚本创建序列

Question

我正在尝试在 DUAL 中创建一个序列。脚本如下:

BEGIN
EXECUTE IMMEDIATE 'CREATE SEQUENCE "SEQ_DummyID"  MINVALUE 1000000 MAXVALUE 9999999 INCREMENT BY 1 START WITH 1000000 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL' ;

COMMIT;
END;

该脚本在一个数据库中的一个数据库中有效，但在另一个数据库中无效。我得到的错误是:

ORA-00933: SQL command not properly ended

没有语法更改，为什么会出现此错误？

Answer 1

如果您只是删除部分 NOSCALE，您可以创建您的序列，前提是您使用的是 12c 版本(至少不适用于 12c 版本1 )

Scalable sequences have been available since the first release of Oracle 12c(designed to fix issues related with sequence generated primary keys during huge loads ), but they were not documented and therefore not supported. They are included in the documentation for the first time in Oracle 18c.

and works in 18c