System Index rebuild in Oracle 9i
Posted on 2009-12-22
I am planning to rebuild SYS_C002518 index. i think it is system index.
Reson for rebuild:
one of my dbf file is corrupted and in log file it was showing 'UAI_USER_ACC_INFO' table. so using below query i find the index name:
select index_name from all_indexes
where table_name = 'UAI_USER_ACC_INFO';
My question is, i am planning to rebuild this index using below script.
alter index SYS_C002518 rebuild;
rebuilding this index is there any issues/problems?