Activating SAP Default indexes

[former_member199632]

Hi,

After a fresh SAP installation, our ABAP team request to activate an index on table VBFA

On these fields ;
MANDT
VBELN
POSNN

There is a default index on that VBFA table already. (switched off)
But. There it shows as  "Index does not exist in database system ORACLE"

(check the attached screenshots)

When trying to activate this index, it gives some warnings and activation is not possible...

How to activate this index?

Why these indexes are not activate automatically after the installation?

regards,

Zerandib

  ==============================

===========================================
  Activation of worklist (USHAN / 22.08.2013 / 14:52:17 /)
  =========================================================================

  Technical log for mass activation
     See log USHAN20130822145217:ACT

  Switchable object XINX VBFA-M01 was not activated (switched off)
  Check index VBFA-M01 (USHAN/22.08.13/14:52)
  Index VBFA-M01 is not in the customer namespace
   Index VBFA-M01 is consistent

=========================================================================
  End of activation of worklist
  =========================================================================

[former_member188883]

Hi Zerandib,

Go to Se14

put table name for which index is missing

Select "indexes" tab from the menu bar

Look out for the index which does not exists in oracle database

Once you select the index , click on "Create Database index" using the option background.

Monitor the progress in SM37.

Once the job is completed, you may check the index active in SE14 / SE11.

Regards,

Deepak Kori

[former_member199632]

Hi Deepak,

I have checked that SE14 path

But there, "Create Database Index" tab is disable..

sametime, any idea... why these indexes not activate by default after a fresh sap installation

regards,

zerandib

Message was edited by: Zerandib @

[former_member199632]

Why there is 2 different things in se11 and se14

Check the attached screenshot

in transaction SE14 , it says;

DB Index -> VBFA~0

Index ID-> VBFA - 0

Status -> Active. Saved.

Exists in the database

in transaction SE11, it says;

Index Name-> VBFA M01  Switched Off

Status-> New Saved

Index does not exist in database system ORACLE

Please Clarify

regards,

zerandib

[Reagan]

Hello

But there, "Create Database Index" tab is disable.
why these indexes not activate by default after a fresh sap installation

You are checking the index VBFA-0 and this index is already present at the database level.

The problem you have is with the index VBFA-M01

Have you tried to create the index VBFA-M01 at the database level ?

Regards

RB

[former_member188883]

Hi Zerandib,

If in Se11, the index name is active , could you check in Db02 -> Missing Indexes whether there is any entry. From there as well you can perform "Create in DB" index creation steps.

Hope this helps.

Regards,

Deepak Kori

[Reagan]

Hello

In SE11 the status of the index you are checking is in Saved status. It should be in Active.

The screen shots are for two different indexes.

You need create the missing database index using SE14 and activate the index in SE11

Regards

RB

[Reagan]

Hello

Use Tx SE14 to create the index at the database level.

Regards

RB

[Former Member]

Hi Zerandib

for the activation, i think this is for you

http://scn.sap.com/thread/1630642

reason why not all switches are on, i believe because the systems would become massive and more complicate to manage even for people that don't need all solutions

I would still recommend you to create a custom index for this purpose without activating the std one

Regards

a