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