Re: desc indexes howto
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Wed, 3 Jul 2013 08:32:56 -0700 (PDT)
Message-ID: <1372865576.29149.YahooMailNeo_at_web121602.mail.ne1.yahoo.com>
DBA_OBJECTS will give you that information if it's an index, DBA_CONSTRAINTS will provide details if it's an actual constraint (it's a foreign key constraint you've tried to violate). A basic query of DBA_CONSTRAINTS to return the barest of information regarding that constraint would be:
select d.owner, c.table_name, d.table_name, d.constraint_name, d.r_constraint_name from dba_constraints c join dba_constraints d on d.r_constraint_name = c.constraint_name where d.constraint_name = 'SYS_C0057216' /
This should return the owner, parent table, child table, referencing constraint name and referenced constraint name.
David Fitzjarrell
From: Jose Soares <jose.soares_at_sferacarta.com> To: oracle-l_at_freelists.org
Sent: Wednesday, July 3, 2013 1:15 AM
Subject: desc indexes howto
Date: Wed, 3 Jul 2013 08:32:56 -0700 (PDT)
Message-ID: <1372865576.29149.YahooMailNeo_at_web121602.mail.ne1.yahoo.com>
DBA_OBJECTS will give you that information if it's an index, DBA_CONSTRAINTS will provide details if it's an actual constraint (it's a foreign key constraint you've tried to violate). A basic query of DBA_CONSTRAINTS to return the barest of information regarding that constraint would be:
select d.owner, c.table_name, d.table_name, d.constraint_name, d.r_constraint_name from dba_constraints c join dba_constraints d on d.r_constraint_name = c.constraint_name where d.constraint_name = 'SYS_C0057216' /
This should return the owner, parent table, child table, referencing constraint name and referenced constraint name.
David Fitzjarrell
From: Jose Soares <jose.soares_at_sferacarta.com> To: oracle-l_at_freelists.org
Sent: Wednesday, July 3, 2013 1:15 AM
Subject: desc indexes howto
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-lReceived on Wed Jul 03 2013 - 17:32:56 CEST