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: Drop constraints CASCADE not working on 10g Express

Re: Drop constraints CASCADE not working on 10g Express

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 24 Nov 2006 17:47:15 +0100
Message-ID: <ek77mo$9fp$01$1@news.t-online.com> 





> To make it work i will have to remove CASCADE and issue an explicit DROP 

> INDEX after removing the constraint...

> 

> This will make it work on both 9i and 10g, correct?

> 




Yes the explicit clause should work in both versions, but to be sure i 
understand you correctly - you issue DROP INDEX as part of ALTER TABLE 
... DROP CONSTRAINT ... statements ? (no need to do it in the separate 
DROP INDEX statement) .



Best regards



Maxim
Received on Fri Nov 24 2006 - 10:47:15 CST












Original text of this message













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