|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02
SEQUENCE statement to change the increment, minimum and maximum values, cached numbers, and behavior of an existing sequence. This statement affects only future sequence numbers.
CREATE SEQUENCE for additional information on sequences
The sequence must be in your own schema, or you must have the
ALTER object privilege on the sequence, or you must have the
SEQUENCE system privilege.
The keywords and parameters in this statement serve the same purposes they serve when you create a sequence.
BYvalue before the first invocation of
NEXTVAL, some sequence numbers will be skipped. Therefore, if you want to retain the original
WITHvalue, you must drop the sequence and re-create it with the original
WITHvalue and the new
MAXVALUEcannot be imposed that is less than the current sequence number.
This statement sets a new maximum value for the
This statement turns on
CACHE for the