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

SEQUENCE [Owner.]SequenceName

Name of the sequence to be altered.

BATCH BatchValue

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 the DROP SEQUENCE statement and then create a new sequence with the same name. For example, to change the MINVALUE, drop the sequence and recreate it with the same name and with the desired MINVALUE.

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