Issue 81018 - Compact table menu option
Summary: Compact table menu option
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-08-25 05:18 UTC by dlairmarc
Modified: 2013-02-07 22:32 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description dlairmarc 2007-08-25 05:18:35 UTC
A menu tool to compact the tables in an OOo embedded database.


A table which is subject to numerous addition and deletion of records will, over
time, become bloated, thus requiring compaction to reclaim previously used
space. At present, the only way to do this is via the Tool/SQL... option and
create and execute an administrative command: SHUTDOWN COMPACT

While this works, it requires administrative knowledge of SQL commands and is
not intuitive. It also requires exiting OOo and restarting after it completes in
order to use the database.
Comment 1 dlairmarc 2007-08-25 19:49:35 UTC
An additional method using Tools/SQL is to execute SHUTDOWN DEFRAG.
This also compacts the database files but does not require closing the database
and reopening it.
Comment 2 christoph.lukasiak 2007-09-04 15:58:24 UTC
valid enhancement
Comment 3 christoph.lukasiak 2007-09-04 15:59:42 UTC
send further to the requirements team