This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
[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' "a_PK" see ORA-02429 on: http://mirrors.spb.ru/oracledocs/server/msg73/ch232.html
Design issue. Not possible to easily fix because of the limitation of dbspec.plist file. 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.