Re: desc indexes howto

From: Gus Spier <gus.spier_at_gmail.com>
Date: Wed, 3 Jul 2013 06:25:50 -0400
Message-ID: <CAG8xnidXBUFccrcRfPwTfb-0qn9jdGrHcNWujJqWUzjkgGq-RA_at_mail.gmail.com>

We just went through this exercise.
Use ALL_CONSTRAINTS to determine the tables involved.

Use ALL_CONS_COLUMNS to determine the columns involved.

DELETE the offending row in the child table.

DELETE the desired row in the original target table.

In our case, cascading referential integrity constraints (foreign keys) compelled us to repeat this process to three levels. (DELETE the grand-child row, then the child row, and finally the target row.

Good luck!

Gus

On Wed, Jul 3, 2013 at 3:15 AM, Jose Soares <jose.soares_at_sferacarta.com>wrote:

> Hi all,
>
> How can I have indexes/constraints info?
>
> I tried to delete a row from a table in my db and I got this message:
>
> (IntegrityError) ORA-02292: integrity constraint (SFERA.SYS_C0057216)
> violated - child record found
>
>
> I can't realize what SYS_C0057216 is and to what it is linked.
> I would like to know how to have information about it.
> Is there a way to do that?
>
> thanks for any help.
> j
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 03 2013 - 12:25:50 CEST