I have this cube that did not have partitioning and so I did a complete re-partition on 0calmoth.
Upon the partitioning I have an FACT index error when I attempt to re-index it. The error is:
CREATE BITMAP INDEX
"SAPSR3"."/BIC/FZSM_C001~090" ON "/BIC/FZSM_C001"
( "KEY_ZSM_C0016" ) PCTFREE 5 INITRANS
2 MAXTRANS 255 STORAGE ( INITIAL 16 K NEXT
2560 K MINEXTENTS 1 MAXEXTENTS UNLIMITED
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1
BUFFER_POOL DEFAULT ) LOCAL PARALLEL TABLESPACE
"PSAPSR3I" NOLOGGING COMPUTE STATISTIC
SQL-END: 06/07/2011 09:55:07 00:00:00
SQL Error: ORA-01408: such column list already indexed
I attempted to drop the indexes, repair them, adjust them using se14.
I'm thinking I need to drop the cube data, then re-index, and re-load the cube.
Any way I can make this adjustment without dropping the data?
Mike