Return
-
Title
Compare/repair does not work. it returns with "0 object compare/repair" and "BAD ROUTE" in compare log -
Description
Running compare/repair for any tables returns right away with 0 object compare/repair.
From the compare log, there are entries like:
desvr 2015-02-02 06:23:51.615932 47218 4048541536 BAD ROUTE
desvr 2015-02-02 06:23:51.615948 47218 4048541536 002: Input line: "TIAACREF_PROD"."LABEL_HISTORY" "TIAACREF_REPORTING"."LABEL_HISTORY" xxx.xxx.xxx.xxx@o.targetdb
desvr 2015-02-02 06:23:51.615948 47218 4048541536 002: Job ID : 213
desvr 2015-02-02 06:23:51.615948 47218 4048541536 002: Source Data : db162088
desvr 2015-02-02 06:23:51.615948 47218 4048541536 002: Parse error message : Unable to verify object
Instead of table_owner.table_name, it will generate: NO_TABLE_COMPARED
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.