Re: Oracle exception USER.INDEX_QUERY violated
Date: Thu, 9 Oct 2008 07:18:51 -0700 (PDT)
Message-ID: <bef2c6c5-9c98-4fd2-8d24-98af94c3fa29@t39g2000prh.googlegroups.com>
On Oct 9, 6:29 am, yossarian <yossaria..._at_operamail.com> wrote:
> tricky wrote:
> > ORA-00001: unique constraint (IBS_O.INDEX_QUERY) violated
>
> IBS_O.INDEX_QUERY is an unique constraint or index and your app is
> violating it. The RDBMS doesn't tell lies :)
>
> Y.
yossarian is correct. If the data does not already exist in the table then depending on how the application gets its data either the source has the key twice or the logic attempts to insert the same row twice.
Note that the error may be the result of logic in a before or after insert trigger on the table you are inserting into and the constraint violation is happening because of this when another table is updated by the logic.
The possibility exists that the index in question should not be unique though that is not usually the case.
HTH -- Mark D Powell -- Received on Thu Oct 09 2008 - 09:18:51 CDT