Kbase P156271: What is the fastest way to move a very large table to a new area?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/1/2010 |
|
Status: Verified
GOAL:
What is the fastest way to move a very large table to a new area?
GOAL:
What is the fastest way to migrate a very large table to a new area?
GOAL:
What is the fastest way to migrate a very large table to a new area if space is not a limitation?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
1) Dump the definition of the table to a .df file (make sure the option for "Maintain Position information for r-code compatibility" is enabled)
2) Dump the data for the table
3) Make an add.st to define a new area large enough to hold the table and if desired the indices of the table
4) Modify the .df to change all area references to point to the new area (or if desired change just the references for the table but not the indices)
5) Rename the original table in the data dictionary to something other than the original table name (eg. oldTableName)
6) Load the modified .df
7) Load the data into the table which is in the new area
8) Rebuild the indices
9) Over time the data in the original renamed table may be removed slowly or all at once.
Be aware if the table is removed all at once this will likely be treated as single transaction and may result in significant growth within the Before Image file(s).