Kbase P8179: How to use the tablemove command.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/01/2011 |
|
Status: Verified
GOAL:
How to use the tablemove command
GOAL:
How to move tables out of the schema area
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
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. See P50766, "How to improve the performance of tablemove process?" for more information.
Proutil's tablemove will exclusively move the tables, indexes are left in the previous area.
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 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.