Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Row in USER_INDEXES table not deleted when constraint is dropped
On Fri, 06 Oct 2006 21:50:19 -0700, Luso Joe wrote:
> My guess is there is a link between DBA_DEPENDCIES, DBA_INDEXES and
> DBA_CONSTRAINTS, but I won't be able to check till next week. I'll
> followup if I find something substantive, unless someone beats me to
> it.
SQL> select distinct delete_rule, constraint_type from dba_constraints;
DELETE_RU C
--------- -
V U P ? C
8 rows selected.
SQL>
-- Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com) *** Feel free to correct me when I'm wrong! *** Top posting [replies] guarantees I won't respond.Received on Sat Oct 07 2006 - 00:07:20 CDT