#12261: Alter sequence in Oracle12c

abhishekj(*) reported 2014-06-05T12:49:17Z · last modified 2014-06-21T18:31:01Z

Dev	NielsGron
QA	ivangron

Priority	Low
Complexity	Unknown

Component	DB - Oracle
Version	Future

Aqua Data Studio 15.0.0-dev-309
Build #: 38294
Built on: 2014-Jun-04 01:50:45 PM

Steps to Reproduce:

1.Connect to Oracle12c database.

2.Create the below sequence:

CREATE SEQUENCE "c##project"."student"

INCREMENT BY 1

START WITH 1

NOMAXVALUE

NOMINVALUE

NOCYCLE

CACHE 20

NOORDER

Sequence created successfully.

Now go to sequence option from the tree node,expand it and select sequence "project",right click on it and select option Alter.

Here it is observed that we cannot change min and max value when we alter the sequence.

With the below script we can change the min max value when we alter the sequence:

ALTER SEQUENCE customers_seq 
   MAXVALUE 1500

We can also alter Cycle and Cache for the customer_seq sequence by following script:

This statement turns on CYCLE and CACHE for the customer_seq sequence:

ALTER SEQUENCE customers_seq 
   CYCLE
   CACHE 5

All Comments (1) Change History

ivangron 2014-06-21T18:31:01Z

This is a feature request. Reassigning to niels and future version for prioritization