recreate indexes

select 'drop index ' index_name ';' from all_indexes where table_owner='ownername'
/

SELECT 'alter index ' index_name ' rebuild ; ' FROM all_indexes where table_name='tablename' or table_owner='ownername'
/