Re: Strange ORA-02429 error when inserting into an iot
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: Craig.Healey@xxxxxxxxxxx
- Date: Wed, 08 Dec 2010 11:14:38 +0100
Craig,
Is it possible that you play on constraints, deferring checks for
instance? There is a kind of logical disconnect between constraints,
which refer to data, and the physical indexes that implement them - the
physical index is or isn't here (especially in an IOT, where the table
is the same as the index) and cannot be "deferred".
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>
On 12/08/2010 10:56 AM, Craig.Healey@xxxxxxxxxxx wrote:
> 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:
