drop table and index.
create table and index again.
i think, it make incorrect index after adding column.
i don’t know exact reason.
ex)
create table customer (id number);
alter table customer add name varchar2(10);
insert into customer(id,name) values (1,’john’);
select * from customer; –> 1 rows
select id from customer where name = ‘john’; –> 0 rows