Skip to Content
0
Former Member
May 12, 2008 at 06:19 AM

Query failing

22 Views

Hi,

zzflame_agrt_no & bukrs_vf are non-primary fields in the table VBAK.

select vbeln

auart

vkorg

zzflame_agrt_no

bukrs_vf

from vbak

up to 1 rows

into wal_vbeln

where zzflame_agrt_no = '1212121'

and bukrs_vf = ' DE'.

This query is dying. To improve the performance I created a secondary index in the table VBAK which already has 8 indexes and when I created the index it says "Index does not exist in database system ORACLE ".

I selected non-unique index( Index on all DB systems).

1. How do i remove this message "Index does not exist in database system ORACLE "?

2. My query is for just 1 row but is failing. How do i get the query working ?

Thanks

SMS