What exactly does 'Activate and Adjust Database" mean?

[vince_laurent]

In SE14, if I put a table or index name in I get the button options to creat/delete/and Activate and Adjust Database. What does that last one mean? If I have an existing index does it reorg it? Does it just rematch the SAP internals to the Oracle database?

Thanks

Vince

[Former Member · Accepted solution]

Hi,

For an Index in SE14-->Activate & Adjust database is nothing but rebuilding of Index. if you see any missing indexes in DB02 then you can rebuild those using this option.

This is specially helpful when your Index size becomes larger than table(more than table size). You can free some space by monitoring large size index whose size is greater than & rebuild then using SE14-->Activate & Adjust with database.

In case of table this option is risky as it may result in data loss

Hope this helps.

Thanks,

Sushil

[vince_laurent]

I found out that it does a drop/recreate vs rebuild online.

Thanks for all the replies!

[former_member204746]

you can use these buttons safely on indexes, but be very careful to use those on a table.... especially the DELETE button!

So, basically, SAP has its own data dictionary. if you add/delete/modify fields or their properties from SE11, you need to activate these changes so that your Database knows about them and adapts to the changed made.

[markus_doehr2]

Acitvate and Adjust means, that, if you change the index (add/remove a field), it will create the new index, drop the old one and rename the created to the actual one.

Markus