Re: Constraints Problem

Hello Mahip,

I guess there is an index in the name RPO_PK (agree with Jay Miller.) So when u r trying to create the primary key, it is trying to create an index with the same name and the conflict occurs. So it returns with an error 02264.

Check the system tables again with the same name and any object_type (not only for constraints) ..... u may find ur answer...

Good luck.
----- Original Message -----
From: Miller, Jay <JayMiller_at_TDWaterhouse.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, May 09, 2000 10:44 PM
Subject: RE: Constraints Problem

> Did you check dba_constraints?
>
> Also, might you have an index with that name? If so, try dropping the
index
> and then creating the constraint (it will automatically recreate the
index).
>
> -----Original Message-----
> Sent: Tuesday, May 09, 2000 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Lists,
> I am having a strange problem -
>
> 1 ALTER TABLE RESPROFOUT
> 2 ADD (CONSTRAINT RPO_PK PRIMARY KEY
> 3 (RPO_STATUS
> 4 ,RPO_FLUID
> 5 ,RPO_JOBNUM
> 6 ,RPO_RESCODE
> 7* ,RPO_PERNUM))
> SQL> /
> ADD (CONSTRAINT RPO_PK PRIMARY KEY
> *
> ERROR at line 2:
> ORA-02264: name already used by an existing constraint
>
> I checked User_constraints, All_constraints, User_objects, All_objects
> but nowhere I found an entry for the above mentioned existing
> constraint.
> When I try to issue the same statement with a different constraint name,
>
> It goes well. But this particular constraint name "RPO_PK" is giving
> the error and I am not able to see this constraint in Data dictionary.
> Pl. Help,
> Tia,
> Mahip
>
> --
> Author: Mahip Narayan
> INET: Mahip_at_mahindrabt.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author: Miller, Jay
> INET: JayMiller_at_TDWaterhouse.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed May 10 2000 - 03:55:01 CDT