![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DB oracle sequence reset 0 by new month
码农110
工作多年了,在csdn也多年了,却什么也没留下....
展开
-
Dont't recreate the sequence! You would invalidate all independent objects and l
原文出处:https://community.oracle.com/message/4016489#4016489 Dont't recreate the sequence! You would invalidate all independent objects and lose all privileges granted for the sequences.Instead try...原创 2014-07-29 10:08:50 · 99 阅读 · 0 评论 -
Dont't recreate the sequence! You would invalidate all independent objects and l
Instead try this: SQL>CREATE SEQUENCE SEQ_TEST 2 START WITH 1 3 INCREMENT BY 1 4 MINVALUE 1 5 MAXVALUE 9999999; Sequence created. SQL> SQL>SELECT SEQ_TEST.NEXTVAL 2 FROM all_objects WHERE ROWNUM &a原创 2014-07-29 10:08:50 · 71 阅读 · 0 评论