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.
_________________
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
Blog:http://blog.rthand.com
Righthand .net consulting and software development
http://www.rthand.com

[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 ;
_________________
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
Blog:http://blog.rthand.com
Righthand .net consulting and software development
http://www.rthand.com

[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