Re: desc indexes howto

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Wed, 3 Jul 2013 08:44:32 -0300
Message-ID: <CAJ2dSGQ8V0B0ryiWOXJ9bXqJZbqB8Wps5mgHjx4FkCDgts+OGg_at_mail.gmail.com>



The error is quiet plain:
ORA-02292: integrity constraint (SFERA.SYS_C0057216)

SYS_C0057216 is a foreign key constraint. This means you are trying to delete a record that has a child record in another table. You need to find that record and delete it first. The way to do that is, as Gus said, from all_constraints and all_cons_columns.

Or you could use some to to generate an ERD of the schema so you understand it better and can visually identify the child tables.

hth

Alan.-

On Wed, Jul 3, 2013 at 4: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 - 13:44:32 CEST

Original text of this message