Re: Renaming a sequence

Not quite Conner...it only appears to work because if you try the following:

SQL> create sequence x;

Sequence created.

SQL> select x.nextval from dual;

  NEXTVAL

        1

SQL> select x.nextval from dual;

  NEXTVAL

        2

SQL> rename x to y;

Table renamed.

SQL> select y.nextval from dual;

  NEXTVAL

       21

Not exactly the result one is looking for...but rather another of Oracle's great mysteries.

• Tom Williams Senior Programmer Auga ApS

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3BFB8EEF.2D65_at_yahoo.com...
> Silver wrote:
> >
> > If possible, how do I rename a sequence ? Oracle 8.1.7 on Solaris.
> > Thanks.
> > Silver
>
> mcdonac_at_db1> create sequence x;
>
> Sequence created.
>
> mcdonac_at_db1> rename x to y;
>
> Table renamed.
>
> mcdonac_at_db1> select y.nextval from dual;
>
> NEXTVAL
> ----------
> 1
> Interesting, but it appears to work.
>
> --
> ==============================
> Connor McDonald
>
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue..."
Received on Thu Nov 22 2001 - 09:27:14 CST