Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
SQL Statements: ALTER CLUSTER to ALTER SEQUENCE, 21 of 21
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;
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|