Sequence Resetting

—————— CS Sequences maintenance——————-

column last_number format 9999999999999999

select * from user_sequences where sequence_name in (‘UOC_ORDER_SEQ_ID’);

select 2300000000 – CurrVAl – 20 LAST_NUMBER from dual;

alter sequence UOC_ORDER_SEQ_ID increment by NOCACHE;

Increment Once.

select UOC_ORDER_SEQ_ID.nextval from dual;

Confirm Value comes to 2300000000. After that

alter sequence UOC_ORDER_SEQ_ID increment by 1 NOCACHE;

alter sequence UOC_ORDER_SEQ_ID maxvalue 2399999999 NOCACHE;