Kbase P132844: Adding constraints via ALTER TABLE statement creates indexes in the Schema Area
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/16/2011 |
|
Status: Verified
SYMPTOM(s):
Adding constraints via ALTER TABLE statement creates indexes in the Schema Area
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
Bug# OE00171196
CAUSE:
Prior to OpenEdge 10.2A, ALTER TABLE syntax did not include the "AREA" clause. By default it placed constraint indices in the Schema Area
FIX:
Upgrade to OpenEdge 10.2A or later. If it is not possible to upgrade, as a workaround it is possible to use the index move utility (PROUTIL IDXMOVE) to relocate constraint indexes into desired storage areas. For example:
proutil dbname -C idxmove "Table_Name"."SYS_Index_Name" "Area_Name"