SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-08104: this index object 4145783 is being online built or rebuilt

IshanJul 7 2013 — edited Jul 8 2013

Hi All,

Oracle Version: 11g R2

I am trying to build a clause with the following Anonymous Block

begin

for i in (
            select index_name, partition_name from user_ind_subpartitions where status = 'UNUSABLE'
           )
loop
       execute immediate 'ALTER INDEX ' || I.INDEX_NAME || ' REBUILD SUBPARTITION ' || I.PARTITION_NAME || ' PARALLEL ( DEGREE 4) ' ;

end loop;
end;

But only SOMETIMES it give me error ORA-08104.

A google search shows that I have to have "ONLINE" clause in the rebuild index for this error to come. But I am not using any online clause in the query. Also, session wasn't killed when I was rebuilding the index. Then why this error?

Can anyone please help on this?

Thanks,

Ishan

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2013

Added on Jul 7 2013

3 comments

3,622 views