Constraints Problem

From: Mahip Narayan <Mahip_at_mahindrabt.com>
Date: Tue, 09 May 2000 13:46:15 +0100
Message-Id: <10492.105229@fatcity.com>

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, Received on Tue May 09 2000 - 07:46:15 CDT