Search notes:

ORA-02429: cannot drop index used for enforcement of unique/primary key

create table tq84_p (
    id   integer,
    txt  varchar2(10),
    constraint tq84_p_pk primary key (id)
);
 
create table tq84_c (
    id_p   integer,
    val    number(5,2),
    constraint tq84_c_fk foreign key (id_p) references tq84_p
);
 
drop index tq84_p_pk;
-- ORA-02429: cannot drop index used for enforcement of unique/primary key
 
alter table tq84_p disable primary key cascade;
 
drop index tq84_p_pk;
-- ORA-01418: specified index does not exist
 
drop table tq84_c;
drop table tq84_p;

See also

Referential integrity: primary and foreign keys.
Other Oracle error messages

Index