Xref: alice comp.databases.oracle.misc:19689
Message-ID: <35F6779C.ADF733E6@infolog.dk>
Date: Wed, 09 Sep 1998 14:42:04 +0200
From: Henrik Staun Poulsen <hsp@infolog.dk>
Organization: InfoLog Aps
X-Mailer: Mozilla 4.03 [da] (WinNT; I)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
To: Lee Pollington <lee@cursci.co.uk>
Subject: Re: Which rows broke my constraint?
References: <35D968DC.24E44C05@cursci.co.uk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 20
X-Complaints-To: abuse@telia.dk
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news-feed.inet.tele.dk!bofh.vszbr.cz!masternews.telia.net!newsfeed101.telia.com!d2o102.telia.com!t7o102p20.telia.com

Lee,

It sounds as if you have a situation where you need more than one index?

Would things work if you had a primary key, and one or more unique keys?

As in
ALTER TABLE DAYTYPE     ADD CONSTRAINT PK_DAYTYPE        PRIMARY KEY
(DAYTYPE_1, DAYTYPE);
ALTER TABLE DAYTYPE     ADD CONSTRAINT UK_DAYTYPE        UNIQUE
(DAYTYPE, LINENO);


Best regards
Henrik