You can rename it straight out:

rename old_sequence to new_sequence;

It would say table renamed but you can ignore it. Your sequence will be renamed.

Make sure that you modify your old sequences to set nocache on. Otherwise your new renamed sequence will have the cache sequences incremented.

SQL> select junkseq.nextval from dual;

NEXTVAL
----------
100

SQL> rename junkseq to newseq;

Table renamed.

SQL> select junkseq.nextval from dual;
select junkseq.nextval from dual
*
ERROR at line 1:
ORA-02289: sequence does not exist


SQL> select newseq.nextval from dual;

NEXTVAL
----------
101

[Edited by kris109 on 06-28-2001 at 12:11 PM]