topic Re: Index does not exist in database system ORACLE?????? in Application Development and Automation Discussions

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

Former Member — Wed, 27 Jun 2007 15:35:42 GMT

Hi Experts,

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

Index KNA1~Z01 exists in database system ORACLE

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

Index does not exist in database system ORACLE

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.

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

Former Member — Wed, 27 Jun 2007 15:39:05 GMT

Try activating it.

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

Rob

Message was edited by:

Rob Burbank

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

Former Member — Wed, 27 Jun 2007 15:40:31 GMT

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

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

Former Member — Wed, 27 Jun 2007 15:45:43 GMT

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?

2- Just activating the index is enough?

thanq.

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

Former Member — Wed, 27 Jun 2007 15:49:24 GMT

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?

2- Just activating the index is enough?

thanq.

Message was edited by:

Srikhar

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

Former Member — Wed, 27 Jun 2007 15:49:50 GMT

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

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

Former Member — Thu, 19 Jul 2007 13:49:52 GMT

hi,

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

Regards

rachsystem

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

Former Member — Thu, 15 Apr 2010 10:16:24 GMT

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.