We have an ERP6 system on 11204 oracle. Have a 500gb index that has an inconsistency (SE14 DB UTILITY CHECK OBJECT check shows the field names on SAP level are as expected but don't match what is the field names on the DB - those are all SYS_NC000<xx>$ where xx=some number......At the DB level the same index shows those SYS_NC* values for the field names in DBA_IND_COLUMNS view too.
I've dropped the index in SE14 and recreated at the DB LEVEL (w/ correct field names) using PARALLEL 16 to speed it up.......but after that completed in 8hrs, the field names in DBA_IND_COLUMNS still show as SYS_NC* ........
I fixed another one that was similar but much smaller - in that case I used SE14 - ACTIVATE AND ADJUST DATABASE option (which triggers a CREATE INDEX w/ no parallelism).
QUESTIONS:
1) anyone seen this SYS_NC* stuff before and have any guidance?
2) is it possible to use PARALLEL clause from the SE14 ....STORAGE .....FOR NEW CREATION option? I tried following note#1907408....that note has the keyword Parallel listed........but doesn't go into any detail or actually show how PARALLEL could be used. I've tried but can't figure out a way to do it.