Drop constraints CASCADE not working on 10g Express

From: QDL <qdl_at_qdl.qdl>
Date: Fri, 24 Nov 2006 15:13:39 +0100
Message-ID: <4566fe9f$0$3215$4fafbaef@reader2.news.tin.it>

Hello everyone,

I have a problem with a table which has a primary key. I want to delete this primary key in order to be able to create a different one. In Oracle 9i I used to issue:

ALTER TABLE xxx DROP CONSTRAINT "PK_XXX" CASCADE;

and I deleted BOTH the constraint AND the primary key.

If i issue that command on my Oracle 10g Express, the constraint is deleted but PK_XXX is still there preventing me to create a new one with the same name...

Is this a problem with 10g Express, something has changed in the way CASCADE works?

Thanx in Advance
Paolo Received on Fri Nov 24 2006 - 08:13:39 CST