UPDATE SEQUENCES IN ORACLE :


C:\Users\Administrator>sqlplus sys/USERPASS@gip02 as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 6 18:15:45 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn GIP_PKT002_0404/USERPASS@gip02
Connected.
SQL> select * from user_sequences where sequence_name like '%IP%';

SEQUENCE_NAME                   MIN_VALUE  MAX_VALUE INCREMENT_BY C O CACHE_SIZE
------------------------------ ---------- ---------- ------------ - - ----------
LAST_NUMBER
-----------
TELUS_IPID_SEQ                   95000000 1.0000E+11            1 N N         20
   95000420


SQL> select TELUS_IPID_SEQ.nextval from dual;

   NEXTVAL
----------
  95000402

SQL> alter sequence TELUS_IPID_SEQ increment by 200000;

Sequence altered.

SQL> select TELUS_IPID_SEQ.nextval from dual;

   NEXTVAL
----------
  95200402

SQL> alter sequence TELUS_IPID_SEQ increment by 1;

Sequence altered.

SQL> select TELUS_IPID_SEQ.nextval from dual;

   NEXTVAL
----------
  95200403

SQL> select TELUS_IPID_SEQ.nextval from dual;

   NEXTVAL
----------
  95200404

SQL> select TELUS_IPID_SEQ.nextval from dual;

   NEXTVAL
----------
  95200405

SQL> select TELUS_IPID_SEQ.nextval from dual;

   NEXTVAL
----------
  95200406