DROP SEQUENCE

The DROP SEQUENCE statement removes an existing sequence number generator.

If the sequence is replicated across an active standby pair and if DDL_REPLICATION_LEVEL is 3 or greater, the DROP SEQUENCE statement drops the sequence from the active standby pair for all databases in the replication scheme. See Making DDL Changes in an Active Standby Pair in the Oracle TimesTen In-Memory Database Replication Guide for more information.

Required Privilege

No privilege is required for the sequence owner.

DROP ANY SEQUENCE for another user's sequence.

Usage with TimesTen Scaleout

This statement is supported with TimesTen Scaleout.

SQL Syntax

DROP SEQUENCE [Owner.]SequenceName

Parameters

Parameter	Description
`[Owner.]SequenceName`	Name of the sequence number generator.

Description

Sequences can be dropped while they are in use.
If you are using TimesTen Scaleout, you can modify the batch value with the ALTER SEQUENCE statement. Otherwise, to alter a sequence, 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.
If the sequence is part of a replication scheme, use the ALTER REPLICATION statement to drop the sequence from the replication scheme. Then use the DROP SEQUENCE statement to drop the sequence.

Examples

The following statement drops mysequence:

DROP SEQUENCE mysequence;