Re: Problem creating sequences - Oracle 8.0.5

The syntax should be
CREATE SEQUENCE new_seq MINVALUE 1 MAXVALUE 999999999999 CYCLE;

Dowson

"Hale, Robert (EXCHANGE:CREST:V212)" wrote:

> Hi,
> I'm relatively new to Oracle (actually) just started using it
> again after a substantial absence) an am having trouble creating
> a sequence.
>
> When I issue the command "create sequence new_sequence", the
> sequence is created just fine. However, when I attempt to add
> some more options to the create statement I get the error
> "ORA-00933: SQL command not properly ended".
>
> For example, issuing the command "create sequence new_seq minval
> 1 maxval 9999999999 cycle" results in the above error.
>
> Can anyone spot what I'm doing wrong?
>
> --
>
> Rob Hale
> Software Designer - Nortel INM NETWORKS
> mailto:rhale_at_nortelnetworks.com | When in doubt,
> (604) 244 - 4255 | pedal like mad !
> O
> /\_`
> _4\--\_
> //\_\//\\
> ____\_/_ `\_/______
Received on Wed Oct 20 1999 - 20:56:14 CDT