cancel
Showing results for 
Search instead for 
Did you mean: 

Table Reorganization

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (0)