topic Re: Checking table index consistency in Application Development and Automation Discussions

Checking table index consistency

Former Member — Sun, 11 Jun 2006 23:06:09 GMT

Hi Gurus,

I wanted to know to check the table consistency(for indexes) and how to find out how do they differ from the previous versions.

Thanks,

Mike

Re: Checking table index consistency

abdul_hakim — Sun, 11 Jun 2006 23:15:20 GMT

hi jo,

welcome to SDN.

You could use <b>utilities->database object->check in SE11</b> for checking the consistency of your table including indexes.

for tracking the versions use <b>utilities->version->version management in SE11.</b>

Cheers,

Abdul Hakim

Mark all useful answers..

Re: Checking table index consistency

Former Member — Sun, 11 Jun 2006 23:24:58 GMT

thanks abdul,

i am working on 4.7 and we are upgarding to ECC 5.0, i see some tables in FI modules(5.0) have extra indexes and also a message like "index does not exist in database system ORACLE" what does it refer to.

thanks,

jo.

Re: Checking table index consistency

RichHeilman — Sun, 11 Jun 2006 23:27:25 GMT

It seems that SAP is suggesting new indexes without actually activating them. You may activate them from there, and in doing so, will create them in the database.

You might want to check any notes on the subject before doing so, just in case.

Regards

Rich Heilman

Re: Checking table index consistency

abdul_hakim — Sun, 11 Jun 2006 23:29:24 GMT

hi jo,

new versions of tables will be delivered in each release.

so while upgrading u need to use the tranasctio SPAD for importing the changes from prev release.

>>"index does not exist in database system ORACLE" means indexes have not been created in your database.in such case u need to activate the table.also use the path which i have given above for checking the consistency of your table.Also check with your BASIS if problem still persists..

Cheers,

Abdul Hakim

Re: Checking table index consistency

Former Member — Sun, 11 Jun 2006 23:46:08 GMT

Thanks for the replies.

Re: Checking table index consistency

Former Member — Thu, 14 Dec 2006 19:39:07 GMT

Hi,

I have a question , If i active the index it will cause any major problem to database , because already the database table having very large amount of data, so it will take long time to arrange the table entries in the order of the index .