ALTER SEQUENCE
ALTER SEQUENCE [schema
.]sequence_name
[INCREMENT BYinteger
] [MAXVALUEinteger
| NOMAXVALUE] [MINVALUEinteger
| NOMINVALUE] [CYCLE | NOCYCLE] [CACHEinteger
| NOCACHE] [ORDER | NOORDER]
Changes the characteristics of an Oracle sequence (sequence_name), including starting sequence number, range, number of sequence numbers cached in memory, and whether sequential order is preserved.
Specifies the increment between sequence numbers; can be positive or negative (but not 0). The default is 1.
Specifies the largest value the sequence number can reach. The default is NOMAXVALUE, which means the maximum value is 10 27.
Specifies the smallest value the sequence number can reach. The default is NOMINVALUE, which means the minimum value is 1.
Specifies that when sequence numbers reach MAXVALUE they will begin again at MINVALUE.
Specifies that after reaching the maximum value no additional sequence numbers will be generated. This is the default.
Specifies how many sequence numbers Oracle will pregenerate and keep in memory. Note that when the database is shut down, unused sequence numbers stored in the cache will be lost. The default is 20.
Specifies that no sequence numbers are pregenerated to memory.
Specifies that sequence numbers are guaranteed to be issued in order of request.
Specifies that sequence numbers are not guaranteed to be generated in the order of request. This is the default.