ORA-02279 when deploying sequence - v ... | Toad Extension for Eclipse

Forums » Toad Extension for Visual Studio » Toad Extension for Visual Studio

Thread: ORA-02279 when deploying sequence - v 1.5.0

Reply to this Thread

Search Forum

Back to Thread List

	Replies: 1 - Pages: 1 - Last Post: Apr 17, 2012 1:48 PM by: dnorwood_user	Threads: [ Previous \| Next ]

steve_n

Posts: 14
Registered: 11/29/11

ORA-02279 when deploying sequence - v 1.5.0
Posted: Mar 23, 2012 3:39 AM

I get the following message when deploying a sequence to a database where it already exists but the MINVALUE setting is different from what's defined in source:

TEST_SEQUENCE(1,1): Error : Error executing ALTER SEQUENCE STEVE.TEST_SEQUENCE MINVALUE 0 MINVALUE 0: ORA-02279: duplicate or conflicting MINVALUE/NOMINVALUE specifications

In this instance in the target database TEST_SEQUENCE had its MINVALUE set to 1, and in my .osql I've specified MINVALUE 0.

Not a major problem as I can work round it by altering the sequence in the target database before deployment - just looks like a minor bug.

dnorwood_user

Posts: 5
Registered: 5/30/06

Re: ORA-02279 when deploying sequence - v 1.5.0
Posted: Apr 17, 2012 1:48 PM

in response to: steve_n

Steve_n,

I'm real sorry, but we had to discontinue the product (full details here: http://toadworld.com/Blogs/tabid/67/EntryId/876/What-happened-to-Toad-Extension-for-Visual-Studio.aspx). It's still supported, but the forums here will be read-only after today. I would suggest contacting support for help on this topic: https://support.quest.com/contactsupport.aspx

Regards,

Daniel

Pages: 1

Back to Thread List

Threads: [ Previous | Next ]

Legend
	MVP: 2501 + pts
	Guru: 2001 - 2500 pts
	Expert: 751 - 2000 pts
	Enthusiast: 31 - 750 pts
	Novice: 0 - 30 pts
	Moderators
	Helpful answer (5 pts)
	Answered (10 pts)

Toad World

Downloads

Other Resources

Welcome, Guest