Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Cube Re-Partitioning

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

Former Member
Not what you were looking for? View more on this topic or Ask a question