06-27-2007 4:35 PM
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.
06-27-2007 4:40 PM
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
06-27-2007 4:39 PM
Try activating it.
Also check the transport messages to see if there were problems.
Rob
Message was edited by:
Rob Burbank
06-27-2007 4:45 PM
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.
06-27-2007 4:49 PM
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
06-27-2007 4:40 PM
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
06-27-2007 4:49 PM
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
07-19-2007 2:49 PM
hi,
try to run DB02 or SE11 - utilities - database utility - indexes - create index .
Regards
rachsystem
04-15-2010 11:16 AM
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.