備份常用語法~
--修改增量值為1000
ALTER SEQUENCE SCHEMA_NAME.SEQ_NAME INCREMENT BY 1000;
--取得下一個SEQ NUM
SELECT SCHEMA_NAME.SEQ_NAME.NEXTVAL FROM DUAL;
--恢復增量值為1
ALTER SEQUENCE SCHEMA_NAME.SEQ_NAME INCREMENT BY 1;
--確認增量值
SELECT SCHEMA_NAME.SEQ_NAME.CURRVAL FROM DUAL;
--提交
commit;
Written By Felix Hsieh