ORA-04015: ascending sequences that CYCLE must specify MAXV.

mihies

I am getting this error on sequence import:
ORA-04015: ascending sequences that CYCLE must specify MAXVALUE.

This is the SQL DDL:
CREATE SEQUENCE "SOMESCHEMA"."S0492_OPJ_ID" MINVALUE -999999 CYCLE

I manually add MAXVALUE 999999 and then it works.

Oracle 10.2.3.

mihies

Here is the original sequence SQL as SQLDeveloper sees it:
CREATE SEQUENCE "SOMESCHEMA"."S0492_OPJ_ID" MINVALUE -999999 MAXVALUE -1 INCREMENT BY -1 START WITH -1 CACHE 20 NOORDER CYCLE ;

Tom Harris

Hi,

we have fixed the issue with deploying this type of sequence. I will email you details on where to download the new version.

Kind regards, Tom

Tom Harris, Red Gate

Tom Harris

Hi,

this issue has now been released with the latest version of Schema Compare for Oracle.

Many thanks, Tom

Tom Harris, Red Gate