Try recreating your index with ASYNC and update index using INDEX tool so that you don't face issues related to timeout or stuck during the initial load of huge data.

On Tue, May 10, 2016 at 7:26 AM, anupama agarwal <> wrote:
Hi All,

I have a query, I created global index on table of 10,000,000 records. My global index's state is stuck at "BUILDING". I have tried running this query :

alter index accrual_client_ref_id_type_idx on apl_accrual_service.accruals USABLE; 
which says the same. 

The  global index has 10k rows less than main table.  What are my options to fix this? Do I have to rebuild the index to fix this?