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

[Former Member]

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.

[Former Member]

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

[Former Member]

Try activating it.

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

Rob

Message was edited by:

Rob Burbank

[Former Member]

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.

[Former Member]

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]

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

[Former Member]

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]

hi,

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

Regards

rachsystem

[Former Member]

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.