Skip to Content
0
Former Member
Sep 08, 2007 at 11:03 AM

Secondary Index Urgent

28 Views

HI all,

I have created a secondary index for database table BSIS, considering GJAHR

KOSTL SHKZG BUDAT fields to improve the performace of a report.

I transported the request from development to quality and production systems. It reflected in quality but in production system, when I open the table and see the index, it has a message in the index desplay "Index does not exist in database system ORACLE".

When I went through the system->status in development , the database is ORACLE and the release is 9.2.0.2.1. and quality is 9.2.0.4.0 and the production is 9.2.0.5.0. Is this the problem why the system is not accepting this secondary index?? or any other issue ?? Any help is greatly appriciated.

Regards,