Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Row in USER_INDEXES table not deleted when constraint is dropped

Re: Row in USER_INDEXES table not deleted when constraint is dropped

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Sat, 07 Oct 2006 05:07:20 GMT
Message-Id: <pan.2006.10.07.05.07.20.63991@gmail.com>


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

CASCADE R
NO ACTION R
          O

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US