Modify Schema Definition returns the following error when selecting a secured table:
ERROR at line 1:
ORA-00904: "NEXTVER": invalid identifier
ORA-06512: at "WMSYS.LT", line 12136
ORA-06512: at line 1
The same error occurs if you use Workspace Manager's DBMS_WM.BeginDDL. NEXTVER is the column name in this particular case but the same error can occur with other column names.
A session trace is usually required to determine the exact cause of the issue. In most cases, it is due to an index on one of the Workspace Manager columns in the secured table. Modify Schema Definition calls DBMS_WM.BeginDDL and that is where the problem is.
BeginDDL creates a staging table _LTS to handle the ddl operations. The staging table does not contain Workspace Manager columns (with the exception of WM_VALID). Any indexes on the _LT table are recreated on the staging table _LTS. In this case, an index was placed on _LT.NEXTVER so beginDDL was trying to recreate the index on the _LTS table. Since the NEXTVER column does not exist in _LTS, the error ORA-00904: "NEXTVER": invalid identifier is returned.
To fix this problem, you need to determine what column is causing the problem and if it is related to an index. If so, the following will will fix the problem:
4. Then try beginDDL or Modify Schema Definition again. It should work correctly this time.