Kbase P100023: Too many steps required to totally remove an area containing tables.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/30/2008 |
|
Status: Verified
SYMPTOM(s):
Too many steps required to totally remove an area containing tables.
The proutil truncate area command needs to be simplified.
1. proutil dbname -C truncate area "Area_Name"
2. proutil dbname -C idxbuild all -G 0 (you can't delete table without primary index enabled)
3. Go into data dictionary and delete table.
4. proutil dbname -C truncate area "Area_Name" (previous truncate area would have recreated template records for tables so this will remove them)
5. proutil dbname -C truncate bi -G 0 (you can't do a prostrct remove until you truncate bi).
6. prostrct remove dbname d "Area_Name"
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
Enhancement Request# OE00112750
FIX:
This Enhancement has not been implemented in the product. The proutil truncate area command should be simplified so that you don't need to go through all of those steps when completely removing an area. Doing this will make database administration less complicated.