Oracle 12.2-替换NOPARTITION功能 [英] Oracle 12.2 - Replacement of NOPARTITION feature

问题描述

我有Oracle版本12.2.0.1.0

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 ;

直到我删除NOPARTITION，该脚本才不会出现以下错误:

This script isn't working with below error until I remove NOPARTITION :

   ORA-00933: SQL command not properly ended

我在AskTom中发现

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.

12.1中存在一个错误，该错误通过dbms_metadata公开.它不再在12.2中发生

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.

这篇关于Oracle 12.2-替换NOPARTITION功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！