[Nb Build 200310150100, Oracle Thin]
DB Explorer generates command like:
'drop index "SCOTT"."a_PK"'
which throws err: ORA-02429 cannot drop index
used for enforcement of unique/primary key
it should be:
'ALTER TABLE "AA" DROP CONSTRAINT'
see ORA-02429 on:
Design issue. Not possible to easily fix because of the limitation of
It needs to define two commands for index node and then decide if it
is a PK or ordinary index and execute the right command.
This requires a re-architecture to use something like DDLUtils rather than dbspec.plist. Let's see if we can fix this
in the next release.
Reassigned to new owner.