Oracle how to reset sequence nextval

发布时间：2020-12-12 15:51:18 所属栏目：百科来源：网络整理

导读：2 Solutions: 1. drop and re-create it drop sequence seqname; create sequence seqname start with NEWVALUE ... ( Notice: don't forget about sequence's privilege ) 2. alter sequence alter sequence seqname increment by AVALUE -- (e.g.,expected

2 Solutions:

1. drop and re-create it

drop sequence seqname;

create sequence seqname start with NEWVALUE ...

(Notice: don't forget about sequence's privilege)

2. alter sequence

alter sequence seqname increment by AVALUE -- (e.g.,expected - currentVal);

- When AVALUE is a positive number,seqname's value will be increased.

- When AVALUE is a negative number,seqname's value will be reduced.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!