Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-02 |
|
|
View PDF |
Use the ALTER
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.
See Also:
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 ALTER
ANY
SEQUENCE
system privilege.
alter_sequence::=
The keywords and parameters in this statement serve the same purposes they serve when you create a sequence.
INCREMENT
BY
value before the first invocation of NEXTVAL
, some sequence numbers will be skipped. Therefore, if you want to retain the original START
WITH
value, you must drop the sequence and re-create it with the original START
WITH
value and the new INCREMENT
BY
value.MAXVALUE
cannot be imposed that is less than the current sequence number.
See Also:
|
This statement sets a new maximum value for the customers_seq
sequence:
ALTER SEQUENCE customers_seq MAXVALUE 1500;
This statement turns on CYCLE
and CACHE
for the customers_seq
sequence:
ALTER SEQUENCE customers_seq CYCLE CACHE 5;