To restart the sequence at a different number

最新推荐文章于 2024-01-20 06:00:00 发布

最新推荐文章于 2024-01-20 06:00:00 发布 · 136 阅读

文章标签：

#Cache

Oracle 专栏收录该内容

81 篇文章

订阅专栏

本文介绍如何在数据库中重新启动一个序列号到特定数值的方法。首先需要删除原有的序列，然后创建一个新的序列并设置起始值为200000，最大值为999999999999999999999999999，最小值为1，并禁止循环。接着创建公共同义词并授予不同角色选择权限。

To restart the sequence at a different number, you must drop and re-create it.

DROP SEQUENCE EDGE21.GMI_SEQ;

CREATE SEQUENCE EDGE21.GMI_SEQ
START WITH 200000
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER;

DROP PUBLIC SYNONYM GMI_SEQ;

CREATE PUBLIC SYNONYM GMI_SEQ FOR EDGE21.GMI_SEQ;

GRANT SELECT ON EDGE21.GMI_SEQ TO EDGE21_PRIV;

GRANT SELECT ON EDGE21.GMI_SEQ TO EDGE21_RO;

GRANT SELECT ON EDGE21.GMI_SEQ TO EDGE21_RW;

GRANT SELECT ON EDGE21.GMI_SEQ TO EDGE21_RWD;