Skip to Content
Former Member
Feb 12, 2014 at 03:54 PM

SAP Mig Import -- Index creation issue - ORA-01408


Good day SCN,

I have a SAP Heterogenous R3load Migration Import issue with index creation on a BI table (BW SEM system)

The ORACLE error is: ORA-01408: such column list already indexed

The index is "/BIC/E100026~P" on table "/BIC/E100026"

Check the attached full definition of this object from the SAPFACT_1.STR file.

You can see that there are many other indexes on this BI table generated, and this "~P" index essentially includes the fields from all the other single-field indices.

The index though does exist on the source database, so it is currently unclear to me why it can exist on the source but not be allowed on the

I can of course just set the TSK file to ignore ("ign") the index but I would rather understand this issue fully so that I can plan a process to deal with such issues correctly.

Regards to all