RE: Constraints Problem

Check the DBA_CONSTRAINTS table for RPO_PK

Rick

> -----Original Message-----
> From: Mahip Narayan [SMTP:Mahip_at_mahindrabt.com]
> Sent: Tuesday, May 09, 2000 10:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Constraints Problem
>
> 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).
Received on Tue May 09 2000 - 10:49:39 CDT