on 02-23-2009 8:29 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I found out that it does a drop/recreate vs rebuild online.
Thanks for all the replies!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.