Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

secondary table index disapears (is deleted automatically)

Former Member
0 Kudos
110

After creation and transport of two secondary table indexes into productive system, these indexes become invalid after some time and it is necessary to create them again in SE14.

Both indexes were created in SE11 and both consist of two fields.

Table definition:

MANDT type CLNT lenght 3 - key field

VBTYP type CHAR lenght 1 - key field

VBELN type CHAR lenght 10 - key field

TEMPB type CHAR lenght 2 - key field

TCOUNT type INT2 lenght 5 - key field

SHPZG type CHAR lenght 1

SCNAM type CHAR lenght 12

SCDAT type DATS lenght 8

SCZET type TIMS lenght 6

RECZG type CHAR lenght 1

RCNAM type CHAR lenght 12

RCDAT type DATS lenght 8

RCZET type TIMS lenght 6

LFDTA type DATS lenght 8

LFTMA type TIMS lenght 6

LFDTD type DATS lenght 8

LFTMD type TIMS lenght 6

KNDTA type DATS lenght 8

KNTMA type TIMS lenght 6

KNDTD type DATS lenght 8

KNTMD type TIMS lenght 6

PARNRDSP type CHAR lenght 12

Index definitions:

Y01 - non-unique index, index on all database systems, index fields: MANDT, VBELN, SHPZG

Y02 - non-unique index, index on all database systems, index fields: MANDT, VBELN, RECZG

In data dictionary it seems that both indexes are created, they can be seem from SE11 and SE14 (with status active).

However in DB the indexes don't exist, because in SE14 below the status field it says "Does not exist in the database" and the button "Create table index" is active.

If I'd try to create the index (what I did 2 times already), the protocol won't show any errors, index will be created, but after some time (2-3 weeks) the table index probably becomes invalid and the same problem will occur again.

What might be the problem?

R/3 Release 4.6C

DB ORACLE 9.2.0.6.0

3 REPLIES 3

Former Member
0 Kudos
61

hi filip

u r created indexes but the production systems doesn't taking the updated version

of the table it is using the older version

conform that these are stored under same requset or new requset?

0 Kudos
61

both indexes has been transported under new request (other than the one with the table).

Do you suggest to reactivate and transport both the table and the indexes from dev to productive again?

Former Member
0 Kudos
61

Just a guess, but you might try having the DBAs update the statistics for this table.

I've never heard of an index being lost after it's been created in the database.

Rob