I would like to know please if the field nextver is a fixed-length field?. If it's the case, what will happen when this field exceeds the size which is allowed to it.
Thank you in advance Cordially
The nextver column is defined as a varchar2(500). If a row was split between workspaces enough times it would be possible to exceed this 500 character limit. However, this issue has not come up before. If the maximum size was exceeded, the dml or workspace operation(merge, refresh, etc) would fail with an error such as 'ORA-06502: PL/SQL: numeric or value error: character string buffer too small'.
Are you running into a situation where the length of the nextver value is exceeding the 500 character limit ?
A couple of the metadata tables that are used by Workspace Manager also use the 500 character limit, so most likely the error is coming from those tables if you had modified the _LT table. However, updating the length is not anything that we currently support. File an SR if you need this looked at more closely.