Skip to Content

What exactly does 'Activate and Adjust Database" mean?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 24, 2009 at 02:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 23, 2009 at 11:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2009 at 01:54 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2009 at 02:55 PM

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

    Thanks for all the replies!

    Add comment
    10|10000 characters needed characters exceeded