Kbase P24174: There are no removable data extents when removing a fixed ex
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/04/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.x
SYMPTOM(s):
prostrct remove db-name d
Removing a fixed extent
There are no removable data extents
CAUSE:
This is by design in Progress 8.x. You cannot remove fixed length extents whether used or unused. In Progress 9.x it is possible to remove unused fixed length extents but not used ones.
FIX:
In order to remove a fixed length extent it will be necessary to create a new database with a different structure file. If there is enough space, you can procopy from the existing database to the new one. Otherwise, probkup to a file or tape, and prorest into the new structure.
The commands are:
prostrct create newdb new.st
procopy olddb newdb
or
probkup olddb <file or device>
prorest <file or device> newdb