Bug 36621 - Cannot delete primary index
Cannot delete primary index
Status: NEW
Product: db
Classification: Unclassified
Component: Code
3.x
Other Linux
: P4 (vote)
: TBD
Assigned To: Libor Fischmeistr
issues@db
:
Depends on:
Blocks:
  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
:


Attachments

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:     
'ALTER TABLE "AA" DROP CONSTRAINT'    
"a_PK"     
     
see ORA-02429 on:    
http://mirrors.spb.ru/oracledocs/server/msg73/ch232.html
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