ALTER SEQUENCE
This statement is supported in TimesTen Scaleout only.
Use the ALTER SEQUENCE
statement to change the batch value of a sequence.
Required Privilege
No privilege is required for the sequence owner.
ALTER ANY SEQUENCE
privilege for another user's sequence.
Usage with TimesTen Scaleout
This statement is supported with TimesTen Scaleout.
SQL Syntax
ALTER SEQUENCE [Owner.]SequenceName BATCH BatchValue
Parameters
Parameter | Description |
---|---|
|
Name of the sequence to be altered. |
|
Valid with TimesTen Scaleout only. Configures the range of unique sequence values that are stored at each element of the grid. The default value is 10 million. |
Description
-
Use this statement to change the batch value for a sequence in TimesTen Scaleout. The change affects future sequence numbers.
-
This statement cannot be used to alter any other values supported in the
CREATE
SEQUENCE
statement. In this case, use theDROP SEQUENCE
statement and then create a new sequence with the same name. For example, to change theMINVALUE
, drop the sequence and recreate it with the same name and with the desiredMINVALUE
.
See Using Sequences in Oracle TimesTen In-Memory Database Scaleout User's Guide for more information.
Examples
To change the batch value for the sequence:
ALTER SEQUENCE myseq BATCH 2000; Sequence altered
See also