cannot index a primary key in oracle

Jeffrey Crawford  2 hours ago
Running the gsh class did add the legacy attributes and I’m no longer getting the error, however in running the gsh -registry -deep It’s showing two indexes missing. However when I try to create them I get a message “ORA-01408: such column list already indexed” for index “grouper_failsafe_id_idx” which may mean that the column already has a unique constraint or be a primary key (I guess you can’t create and index twice for a column) Same thing with “grouper_last_login_mem_idx”

Jeffrey Crawford  1 hour ago
Okay yea so looking at the script the creation of the table identifies a primary key, which, at least for Oracle, creates an index, so trying to create further indexes causes an error:
CREATE TABLE GROUPER_LAST_LOGIN
(
    MEMBER_UUID VARCHAR2(40) NOT NULL,
    LAST_LOGIN NUMBER(38,0),
    LAST_STEM_VIEW_NEED NUMBER(38,0),
    LAST_STEM_VIEW_COMPUTE NUMBER(38,0),
    PRIMARY KEY (MEMBER_UUID)
);
– conflicts with
CREATE UNIQUE INDEX grouper_last_login_mem_idx ON GROUPER_LAST_LOGIN (MEMBER_UUID);

CREATE TABLE GROUPER_FAILSAFE
(
    ID VARCHAR2(40) NOT NULL,
    NAME VARCHAR2(200) NOT NULL,
    LAST_RUN NUMBER(38,0),
    LAST_FAILSAFE_ISSUE_STARTED NUMBER(38,0),
    LAST_FAILSAFE_ISSUE NUMBER(38,0),
    LAST_SUCCESS NUMBER(38,0),
    LAST_APPROVAL NUMBER(38,0),
    APPROVAL_MEMBER_ID VARCHAR2(40),
    APPROVED_ONCE VARCHAR2(1) NOT NULL,
    APPROVED_UNTIL NUMBER(38,0),
    LAST_UPDATED NUMBER(38,0),
    PRIMARY KEY (ID)
);
– conflicts with
CREATE UNIQUE INDEX grouper_failsafe_id_idx ON GROUPER_FAILSAFE (ID);