TST03 table index went missing

[former_member185488]

Dear Colleagues,

I could see that a 'Primary Index' is missing in DB02 transaction and in EWA as well. When I checked the same, I found that table TST03's index TST03~0 is missing.

When I check the same in DB02 under TST03 table, I could see that there is an index which exists as 'TST03~0#$'. If I go to SE14 and check the same then I see that this doesn't exist in the DB and the last change was during 1997 only. I have only 'Create database Index' option in SE14 for TST03~0 using 'Direct'/'BG'/'Mass Processing' method.

Now my doubt as below,

How the index went missing and name changed to 'TST03~0#$'?

Can we create it using SE14? Will there be any impact on Spool generation and saving in SAP?

Please suggest.

Regards,

Jegan Raj

[former_member185488]

Dear Team,

Could you please update your valuable suggestions on this?

Regards,

Jegan Raj

[JamesZ]

Hi Jegan,

Please see SAP note 541538 point 6, the index should created during reorg.

So you can use index rename to change it back.

Best regards,
James

[former_member185488]

Dear Mr.James,

Thank you so much for your valuable reply. Yes, I have gone through it and I have found the reason for this.

Regards,

Jegan Raj

[former_member233657 · Accepted solution]

Hi,

Seems that a reorganization went wrong in past. Delete it and create the correct index afterwards. Please take care of the system load while creating an index.

Kind regards,

Martin

[former_member185488 · Accepted solution]

Dear Mr.Martin,

Yes, you have hitted the nail on my head. Thank you so much. There was a failed reorg and I will rebuild it.

Regards,

Jegan Raj

[Reagan]

Look into the /oracle/<SID>/sapreorg directory to see if there has any table reorg activity lately.

[former_member185488]

Thank You so much Mr.Reagan. Your answer helped me a lot!