Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

ORA-01410: invalid rowid when merging workspace

user558471Jun 9 2017 — edited Jun 9 2017

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2017
Added on Jun 9 2017
1 comment
737 views