LOCAL BITMAP INDEX CREATION on Interval Partition table with 35 million records is very slow.
We have a interval partitioned table W_SLA_XACT_F with 35 Million records.
SQL*Plus: Release 11.2.0.1.0 Production
Local bitmap indexes are taking too much time to build.
Below is one sample index.
CREATE BITMAP INDEX W_SLA_XACT_F_F5 ON W_SLA_XACT_F(COST_CENTER_WID Asc) LOCAL NOLOGGING PARALLEL
Is there any issue with Interval partitioned tables for this version of Oracle.