Strange ORA-02429 error when inserting into an iot

From: <Craig.Healey_at_mail.ing.nl>
Date: Wed, 8 Dec 2010 10:56:18 +0100
Message-ID: <DC068219E0EBA54082D33E4812CC5ED13A0FFE0648_at_ing.com>



Oracle 10.2.0.4
SunOS 5.10

Hi,

We regularly run a script to update multilingual data in an index-organised table. The script deletes records with a particular key, then runs lots of individual insert statements that have been generated from a text file. Yesterday, whilst inserting 63,340 records, it produced the following errors:

ORA-00604: error occurred at recursive SQL level 1 ORA-02429: cannot drop index used for enforcement of unique/primary key

Google and MOS don't help, as they mainly discuss dropping an index, which we're not (explicitly) doing. And there's nothing in the alert log.

I ran it again with the same result. As this is the same file that was run without a problem last week, with the addition of 160 new records, I just ran the new records and got the same error on a particular record. When I ran the insert for that record manually, it worked fine - the error had gone. The new records all worked fine, and the script itself ran perfectly. So, problem solved, but I'd like to know what caused the error in the first place. Anyone seen something similar before?

Regards

Craig Healey



ATTENTION:
The information in this electronic mail message is private and confidential, and only intended for the addressee. Should you receive this message by mistake, you are hereby notified that any disclosure, reproduction, distribution or use of this message is strictly prohibited. Please inform the sender by reply transmission and delete the message without copying or opening it.

Messages and attachments are scanned for all viruses known. If this message contains password-protected attachments, the files have NOT been scanned for viruses by the ING mail domain. Always scan attachments before opening them.


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 08 2010 - 03:56:18 CST

Original text of this message