Re: Composite partitioned table purge causes need for index rebuild

From: Matt <>
Date: Wed, 16 Sep 2009 15:40:02 -0700 (PDT)
Message-ID: <>

The rebuild successfully survived various failures (kill -9, tablespace full etc) but the kill -9 failure required a manual clean up of the data dictionary before another online rebuild could be attempted. This is because the journal table remains after the crash and the next rebuild attempt tries to create a journal table which already exists.

This can be cleaned up by running:


     dbms_repair.ONLINE_INDEX_CLEAN(<object_id>); end;

thanks again for your response. Received on Wed Sep 16 2009 - 17:40:02 CDT

Original text of this message