Return
-
Title
Repair fails with “Tableis in replication, but not to target specified” -
Description
The following errors are observed when a repair is run:
sp_ctrl>repair "OWNER"."TABLE_NAME" at targetserver@O.sid Cannot repair "OWNER"."TABLE_NAME" Invalid specification "OWNER"."TABLE_NAME" at targetserver@O.sid Table "OWNER"."TABLE_NAME" is in replication, but not to target specified repairing 0 of 1 objects 1 object(s) contain errors No objects to repair; no job started -
Cause
Incorrect specification of the target Oracle SID by way of syntax error. The notation for Oracle target starts with “o.” whereas in our case it was specified as “O.” -
Resolution
Correct the target SID specification and re-issue the command. It will work as the following shows:
sp_ctrl> repair "OWNER"."TABLE_NAME" at targetserver@o.sid
repairing 1 of 1 objects
The error can also occur if the if incorrect target route is specified by way of incorrect target server name or incorrect target SID name.
-
Additional Information
For details on the syntax for Repair command, please refer to SharePlex Reference Guide.