Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Compare or repair fails with the message “Cannot set use both include and exclude options”
설명
The following error is observed when running a compare (or repair) with both exclude and include option:
sp_ctrl> compare OWNER.TABLE_NAME include "COLUMN1" exclude " COLUMN2"
Cannot set use both include and exclude options
원인
Compare or repair do not permit use of include and exclude options together.
해결 방안
Compare or repair now support synchronization of a subset of the columns of a table by the use of ‘exclude’ or ‘include’ option. Either one of these two options can be used to achieve the same goal, namely synchronizing some of the columns in a table. But compare does not support use of both these options concurrently. To resolve the problem, use either one of these options and re-run compare.
추가 정보
For details on compare or repair command, refer to Shareplex Reference Guide.
