How to Update(Drop/Create) Sequences in Oracle:


select * from user_sequences where sequence_name like '%IP%';



drop sequence ORACLE_IPID_SEQ;


CREATE SEQUENCE ORACLE_IPID_SEQ
INCREMENT BY 1
START WITH 96800000
MAXVALUE 97000000
MINVALUE 96800000;


select ORACLE_IPID_SEQ from dual;