Skip to Main Content

Oracle Database Discussions

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!

regarding drop constraints

mafaizNov 3 2011 — edited Nov 3 2011
Hi,
I drop constraints for the table using syntax:

ALTER TABLE TB_TEST DROP CONSTRAINT TB_CONS_TEST;
Table altered
Then,i add constraint for the object with same unique constraint name

ALTER TABLE TB_TEST ADD CONSTRAINT TB_CONS_TEST UNIQUE
(COMPANY_CODE,
LOB_CODE,
DIVISION_CODE,
BU_CODE,
GROUP_ID,
ACCT_CODE,
BRANCH_CODE,
);
iam getting the error: ora-00955 name is already used by an existing object

If I use the different name then it is succeding. why I can't use the same name since I dropped it already

Regards,
Faiz
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2011
Added on Nov 3 2011
3 comments
181 views