SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

reg: drop unique index.

Rajnish ChauhanOct 6 2009 — edited Oct 6 2009

hi friends,
how to drop Unique index from the table.when i fire below statement its giving me Error...

Alter Table Employee
Drop Constraints IX_employeename_01

ORA-02443: Cannot drop constraint - nonexistent constraint

Please suggest.

Reagrds,
Rajnish

This post has been answered by ravikumar.sv on Oct 6 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 3 2009

Added on Oct 6 2009

3 comments

594 views