|Oracle8i SQL Reference
Release 2 (8.1.6)
SQL Statements (continued), 17 of 17
To change the increment, minimum and maximum values, cached numbers, and behavior of an existing sequence. This statement affects only future sequence numbers. For additional information on sequences, see "CREATE SEQUENCE".
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 described in "CREATE SEQUENCE". In addition:
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