Kbase P52224: How to perform a tablemove in the most efficient manner
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/18/2009 |
|
Status: Verified
GOAL:
How to perform a tablemove in the most efficient manner
FACT(s) (Environment):
Progress 9.1x
All Supported Operating Systems
OpenEdge 10.x
FIX:
Moving tables without data is fast, efficient, does not adversely affect bi growth and reclaims space in the SCHEMA area.
1. Dump the desired table(s) data.
2. Run a 4GL program to delete all the records from the desired table.
3. Perform a table move after the data has been deleted.
proutil dbname -C tablemove [owner-name] table-name table-area [index-area]
4. Load the tables .d files.