Kbase P76675: How to restructure the database using tablemove and prostrct remove.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/23/2008 |
|
Status: Verified
GOAL:
How to restructure the database using tablemove and prostrct remove.
GOAL:
How to remove tables and areas
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
In the following example (using sports with 9.1D08 on UNIX), the tables Invoice, Customer, Item, Salesrep, State, Local-Default, and Ref-Call from will be moved from the Info Area into a new area, and their associated indexes will be moved into a separate index area. The Info Area will then be removed. The tablemove utility can be used with the database online, but see Solution P19094 and Solution P50766 for the performance considerations involved.
1. prodb sports sports
2. prostrct add sports add.st
/* add.st */
#
d "New Area":9,32 ./sports_9.d1
#
d "Index Area":10,32 ./sports_10.d1
3. prostrct list sports shows that the areas have been added.
4. proserve sports
5. Move the tables and indexes -
proutil sports -C tablemove Invoice "New Area" "Index Area"
proutil sports -C tablemove Customer "New Area" "Index Area"
proutil sports -C tablemove Item "New Area" "Index Area"
proutil sports -C tablemove Salesrep "New Area" "Index Area"
proutil sports -C tablemove State "New Area" "Index Area"
proutil sports -C tablemove Local-Default "New Area" "Index Area"
proutil sports -C tablemove Ref-Call "New Area" "Index Area"
There is now no data in the Info Area, so it can now be removed -
6. proshut sports -by
7. proutil sports -C truncate area
8. prostrct remove sports d "Info Area"
9. prostrct list sports shows that the area and extents have been removed.