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: 

Index does not exist in database system ORACLE??????

Former Member
0 Kudos

Hi Experts,

I created a Secondary Index in DEV, its fine and the message is,

<b><i>Index KNA1~Z01 exists in database system ORACLE</i></b>

I moved it to TEST and there I got the message is like,

<i><b>Index does not exist in database system ORACLE</b></i>

So,

1 - Wht I hv to do now? Shuld I see BASIS people?

2- Why its happened like that? Coz of not enough space?

ThanQ.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

1) First Check the Secondary index in TEST system

2) Look at the Transport Number in DEV system, If this is having error, then it will show you the error details also,

3) If that not moved Properly then you need to create another request for the INDEX and move it again

Regards

Sudheer

7 REPLIES 7

Former Member
0 Kudos

Try activating it.

Also check the transport messages to see if there were problems.

Rob

Message was edited by:

Rob Burbank

0 Kudos

ThanQ Rob,

OK, I did.

But, Its not working for VBAK tabl(actually, I ´created for 4 tables), while others r working!

1 - Anyways, so, after Activating Seconadyr Index, Shuld I come back and Do I need to activate the Table also?

or

2- Just activating the index is enough?

thanq.

0 Kudos

I don't think so. According to the documentation, activating the index creates it in the database. So that should be all you need to do.

Rob

Former Member
0 Kudos

Hi,

1) First Check the Secondary index in TEST system

2) Look at the Transport Number in DEV system, If this is having error, then it will show you the error details also,

3) If that not moved Properly then you need to create another request for the INDEX and move it again

Regards

Sudheer

0 Kudos

thanq sudheer,

I got the return code as 4, so Can I go for creation of new request and there by moving to test?

1 - Anyways, so, after Activating Seconadyr Index, Shuld I come back and Do I need to activate the Table also?

or

2- Just activating the index is enough?

thanq.

Message was edited by:

Srikhar

Former Member
0 Kudos

hi,

try to run DB02 or SE11 - utilities - database utility - indexes - create index .

Regards

rachsystem

Former Member
0 Kudos

I created two indexes in our Development system.

In one instance the index was created via the activate button.

For the other index I had to create the index using SE14.