There is a sequence with min value 100. I want to alter this sequence to min va

There is a sequence with min value 100.
I want to alter this sequence to min value as 101.
If the table has already data in the sequence column as
100,101,102...
Is it possible to do so ?

Question Posted / lmeher.tcs

4 Answers
11245 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the ..

Answer / kiran kumar

The START WITH Value can not changed using ALTER SEQUENCE
command. The sequence must be dropped and recreate a
sequence in different number.

Is This Answer Correct ?

20 Yes

1 No

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the ..

Answer / ranvijay

we can only alter MINVALUE,MAXVALYE,Incremented by and
CACHE of sequence.but not alter START WITH.

Alter sequence sequanceName
incremented by 2
minvalue 101;

Is This Answer Correct ?

6 Yes

4 No

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the ..

Answer / pradeep

Or other way around can be rename the current sequence and
create new sequence with the desired values;

SQL> CREATE SEQUENCE SEQ_TET INCREMENT BY 1 START WITH 100
MAXVALUE 1000000 MINVALUE 99;

Sequence created.

SQL> rename SEQ_TET to seq_test;

Table renamed.

SQL> select * from user_sequences;

SEQUENCE_NAME MIN_VALUE MAX_VALUE
INCREMENT_BY C O CACHE_SIZE
------------------------------ ---------- ---------- -------
----- - - ----------
LAST_NUMBER
-----------
SEQ_TEST 99
1000000 1 N N 20
100

Is This Answer Correct ?

1 Yes

1 No

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the ..

Answer / lova raju allumalla

WE CANNOT ALTER A SEQUENCE START NUMBER BUT IF U WANT TO
CHANGE THE EXISTING DATA IN THE TABLE THEN

ASSUME U HAVE EMPLOYEE TABLE WHERE EMPNO BEGINS WITH 100

UPDATE EMPLOYEE SET EMPNO = EMPNO + 1 WHERE EMPNO IN
(SELECT EMPNO FROM EMPLOYEE);

Is This Answer Correct ?

0 Yes

2 No

Post New Answer