Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
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 ALTER
ANY
SEQUENCE
system privilege.
The keywords and parameters in this statement serve the same purposes described in "CREATE SEQUENCE". In addition:
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.
This statement sets a new maximum value for the ESEQ
sequence:
ALTER SEQUENCE eseq MAXVALUE 1500;
This statement turns on CYCLE
and CACHE
for the ESEQ
sequence:
ALTER SEQUENCE eseq CYCLE CACHE 5;
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|