darkturtle

Oracle, Rename Sequence 업무 요건 : 시퀀스 RENAME 되나요 ? 채번은요 ? 결론 : 시퀀스 Rename 지원 되구요, RENAME 시점에 CACHE 만큼 SEQUENCE 값이 증가 합니다. EX) 현재 LAST_NUMBER 가 100021 이고, CACHE 20 이면 , RENAME 시점에 LAST_NUMBER 가 100041 로 변경됨 RENAME : Use the RENAME statement to rename a table, view, sequence, or private synonym. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/RENAME.html#GUID-573347CE-3EB8-42E5-B..

alter sequence 시퀀스명 restart 매뉴얼상으로는 "To restart the sequence at a different number, you must drop and re-create it." https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-SEQUENCE.html#GUID-A6468B63-E7C9-4EF0-B048-82FE2449B26D https://rogertroller.com/2018/02/20/oracle-18c-alter-sequence-restart/ >>> I’m using 12.1 and the RESTART option worked as well. I hope Oracle document..