Strange ORA-02429 error when inserting into an iot
- From: <Craig.Healey@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Dec 2010 10:56:18 +0100
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.
-----------------------------------------------------------------
Other related posts:
