Please use the Apache issue tracking system for new NetBeans issues ( !!
Bug 36621 - Cannot delete primary index
Cannot delete primary index
Status: NEW
Product: db
Classification: Unclassified
Component: Code
Other Linux
: P4 (vote)
Assigned To: Libor Fischmeistr
Depends on:
  Show dependency treegraph
Reported: 2003-10-15 14:32 UTC by Martin Schovanek
Modified: 2014-01-07 10:36 UTC (History)
0 users

See Also:
Issue Type: DEFECT


Note You need to log in before you can comment on or make changes to this bug.
Description Martin Schovanek 2003-10-15 14:32:53 UTC
[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:     
see ORA-02429 on:
Comment 1 Radko Najman 2003-10-20 14:00:14 UTC
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.
Comment 2 David Vancouvering 2008-11-12 17:32:28 UTC
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.
Comment 3 Jiri Rechtacek 2009-02-10 15:20:43 UTC
Reassigned to new owner.

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2014, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo