找出Obj#为289的对象
SQL> select obj#,name from obj$ where obj#=289;
OBJ# NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
289 I_JOB_NEXT
然后rebuild这个index
SQL> alter index I_JOB_NEXT rebuild;
系统已更改。
或者删除重建
select index_name,column_name from all_ind_columns where index_name='I_JOB_NEXT';
drop index I_JOB_NEXT;
create index I_JOB_NEXT on job$(next_date);