Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Renaming a sequence

Re: Renaming a sequence

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 21 Nov 2001 11:24:31 +0000
Message-ID: <3BFB8EEF.2D65@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 Wed Nov 21 2001 - 05:24:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US