alter sequence START value....
mariasSep 1 2006 — edited Sep 1 2006CREATE SEQUENCE supplier_seq
MINVALUE 1
START WITH 1
INCREMENT BY 1
CACHE 20;
alter sequence test_seq MINVALUE 20000;
ORA-04007: MINVALUE cannot be made to exceed the current value
alter sequence test_seq START WITH 20000;
ORA-02283: cannot alter starting sequence number
I want to reset the MINVALUE to 20000.
is there a way to do this....