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

Compares and synchronizes the schemas of Oracle databases

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

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

Postby mihies » Fri Feb 10, 2012 2:58 pm

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
 
Posts: 64
Joined: Mon Oct 09, 2006 10:01 am
Location: Nova Gorica, Slovenia

Postby mihies » Fri Feb 10, 2012 3:00 pm

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
mihies
 
Posts: 64
Joined: Mon Oct 09, 2006 10:01 am
Location: Nova Gorica, Slovenia

Postby Tom Harris » Mon Mar 05, 2012 6:13 pm

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
 
Posts: 308
Joined: Wed Oct 06, 2004 3:45 pm

Postby Tom Harris » Fri Mar 09, 2012 2:37 pm

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
 
Posts: 308
Joined: Wed Oct 06, 2004 3:45 pm


Return to Schema Compare for Oracle

Who is online

Users browsing this forum: No registered users and 1 guest