How can we help you today? How can we help you today?

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

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
0

Comments

3 comments

Sort by
  • 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 ;
    mihies
    0
  • 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
    0
  • 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
    Tom Harris
    0

Add comment

Please sign in to leave a comment.