Search notes:

ORA-01408: such column list already indexed

create table tq84_ora_01408 (
    id   integer,
    grp  varchar2(20),
    val  number(7,2),
    --
    primary key (id, grp)
);

Trying to create the following index throws ORA-01408: such column list already indexed because the the tuple id and grp is already indexed by the table's primary key.

create index tq84_ora_01408_ix on tq84_ora_01408 (id, grp);

Cleaning up:

drop table tq84_ora_01408;

ORA-01408: such column list already indexed

See also