Use the
PROUTIL TABLEMOVE utility to move a table and its associated indexes from one storage area to another. This command can be run while the database is online or offline but considering running it online specially for large tables. For further information refer to Articles:
TABLEMOVE can exclusively move only tables to another storage area, leaving indexes in the existing area, or move indexes at the same time to the same or a different storage area which is more efficient. Whether indexes are moved with the table record content or not, related indexes are always rebuilt as part of the operation.
For example:To only move a table:
proutil dbname -C tablemove [owner-name] table table-area
proutil sports2000 -C tablemove benefits misc
To move indexes at the same time to the same area as the table or to a different area from the current one, add the name of the area where to store the indexes.
proutil dbname -C tablemove [owner-name] table table-area [index-area]
proutil sports2000 -C tablemove customer "customer area" "index area"
Table Names and Area Names that contain spaces must be enclosed in double quotes.
In the current product implementation, PROUTIL database features exist to move table and/or move index database objects, but not LOB (CLOB/BLOB) database objects. For example, when the table and related indexes are moved to another Storage Area
with PROUTIL -C TABLEMOVE, the related LOBs are left in their existing Storage Area. Prior to OpenEdge 11.6 there are no information in DBANALYS reports for lobs, which leads to the existence of these objects being forgotten in database re-organisation projects. For further advice refer to Articles:
