Return
-
Title
The “repair” errors out with “Table OWNER.TABLE_NAME is not in replication, use force option to repair” -
Description
The following error messages are observed when attempting to repair a table that is not in replication:
sp_ctrl repair OWNER.TABLE_NAME
Table OWNER.TABLE_NAME is not in replication, use force option to repair
-
Cause
The table is not in replication so the repair command will not work.
-
Resolution
Since the table is not in replication, the repair command will not work.
If still wishing to repair the target table, use “repair force” as below:
sp_ctrl repair OWNER.TABLE_NAME force
Please beware that SharePlex will sync the target table with respect to the source table by taking a snapshot of the source table. But given that the table is not in replication, it will again go out of sync sooner or later as and when there is a DML activity on the source table.