community.borland.com
Article #25211: Handling the "Too many versions" error when performing an ALTER statement.
Problem:
Performing many ALTER statements may generate the error -607 "Unsuccessful metadata update
-TABLE
-too many versions".
Solution:
InterBase only allows up to a maximum of 255 versions of each record in the system tables.
Exceeding the limit produces the error shown above. The 255 record version maximum for a record
in a system table is not always reached because system tables experience garbage collection in
the same manner as user tables. Look up the index topic of "Garbage collection" in the online
InterBase help for the specifics on how garbage collection is done.
The solutions available are:
- Perform a backup and restore of the database.
Last Modified: 02-OCT-00