-
Title
The "compare using" errors out with "Object name not of the form OWNER.TABLE" -
Description
The "compare using" errors out with "Object name not of the form OWNER.TABLE" as shown below:
sp_ctrl > compare using config_file_name
Cannot compare "OWNER"."TABLE_NAME"
Invalid specification OWNER.TABLE_NAME target_servername@o.targetSID
Object name not of the form OWNER.TABLE
Cannot compare "OWNER"."TABLE_NAME"
Invalid specification OWNER.TABLE_NAME target_servername@o.targetSID
Object name not of the form OWNER.TABLE
comparing 0 of 2 objects
2 object(s) contain errors
No objects to compare; no job started
-
Cause
There is a syntax error in the config file used in the command “compare using”. -
Resolution
The syntax for the entries in the config file should be:
OWNER.SOURCE_TABLE_NAME OWNER.TARGET_TABLE_NAME target_servername@o.targetSID
whereas in our config file, the syntax used is:
OWNER.SOURCE_TABLE_NAME target_servername@o.targetSID
Correct the syntax and re-issue the command.
-
Additional Information
The error also occurs with any compare or repair command and not just “compare using” or “repair using”.