on 08-18-2008 12:51 PM
Hi,
From our earlywatch report we got the following report.
Which way we can rectify the following error? We are using netweaver 7.
0.1 Table Reorganization
When analyzing your database, we found large or rapidly growing tables or indexes.
Table / Index Name Size of Table / Index [MByte] Recommended SAP Note
ZSE_FEES_TAB~Z03 141,0 332677, 44595
ZSE_FEES_TAB~Z07 122,0
ZSE_FEES_TAB~Z06 112,0
Hallo,
as suggested by note 332677 you can either rebuild the index or drop end recreate the index.
the simplest way is the rebuilding. If you are on oracle you can issue the commands this way:
ALTER INDEX ZSE_FEES_TAB~Z03 REBUILD;
ALTER INDEX ZSE_FEES_TAB~Z07 REBUILD;
ALTER INDEX ZSE_FEES_TAB~Z06 REBUILD;
you have to check whether there is enough space in the tablespace the indexes belong to. You can do it online by adding the keyword online like this:
ALTER INDEX ZSE_FEES_TAB~Z03 REBUILD ONLINE;
Hope this helps,
Ivan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.