At any time, to eliminate or reduce fragmentation, you can manually restructure databases for which you have Database Manager permissions. Data-file blocks are restructured, data files are created, and the index is regenerated so that index entries point to the new data blocks. After a database is restructured, you must recalculate the data.
When databases or outlines are changed in certain ways, database restructures that leave space within data files may be triggered. See Saving Outlines for information about automatic restructures.
Note: | This functionality does not apply to aggregate storage databases. |
To restructure databases manually:
From Enterprise View or a custom view, select a database.
Right-click, and select Restructure.
Optional: To continue working during the restructure process, in the Restructure Database dialog box, select Restructure in the background.
Click OK.
“Optimizing Database Restructuring” in the Oracle Essbase Database Administrator's Guide
alter database (MaxL) in the Oracle Essbase Technical Reference