SAP BASIS INTERVIEW QUESTIONS

_____________________________________________

Question 60: Missing Secondary Index

I have a Win NT/SQL7/R3 kernel -46D. I am missing

one secondary index (Z0CPS0-1) while I run DB02. I

tried recreating the index, but this gives me the error

message "Index could not be setup in the DB." Another

index with the same name exists in the database, but it

is unknown to the ABAP/ 4 Dictionary. How do I

remove the error from the DB02 and resolve the

problem?

A: It is possible that an individual created an index in

the DB directly, which is not recommended. You must

delete the index DB level first, and then create it in SAP.

- 71 -