Hello,
We are using Workspace Manager with geometric tables in a 11.2.0.3 single database in a linux Box.
We are facing, when merging a workspace :
ORA-01410: Invalid ROWID
ORA-06512: in "WMSYS.LT", line 6043
ORA-06512: in líne 1
We are using "DBMS_WM.MERGEWORKSPACE('pilar36',false,false,true);"
There are no other processes changing indexes or corrupted blocks:
SELECT DISTINCT owner, segment_name
FROM v$database_block_corruption dbc
JOIN dba_extents e ON dbc.file# = e.file_id AND dbc.block# BETWEEN e.block_id and e.block_id+e.blocks-1
ORDER BY 1,2;
no rows
This issue happens also after rebooting the database. The workaround is delete workspace and recreate it, but is not acceptable.
Any idea? help will be appreciated.
Best regards.
Bica.