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: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 07 Oct 2006 15:48:56 -0700
Message-ID: <1160261334.473288@bubbleator.drizzle.com> 





HansF wrote:



> I do note that ind$'s 'property' column has a mask value of 0x1000 that

> interprets as "Index was created by a constraint".  From a quick glance at

> the catalog definition, it appears that Oracle does not expose that

> specific property to us.




That seems to be it though I can not find 4097 in sql.bsq.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Received on Sat Oct 07 2006 - 17:48:56 CDT












Original text of this message













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