1.设置SEARCH_CONDITION
2.部分表复制是带有过滤条件的，需要在复制创建时指定过滤条件。在db2=>下执行：http://www.cndba.cn/hbhe0316/article/108039

update ASN.IBMQREP_SUBS set SEARCH_CONDITION='where :NAME=''XXX''' where subname='XXX00001';

Data type: VARCHAR(2048); Nullable: Yes, with default
The search condition that is used to filter rows for the Q subscription or publication. This must be an annotated select WHERE clause, with a single colon directly in front of the names of the source columns. Default: NULL

3.官网链接:http://www.cndba.cn/hbhe0316/article/108039http://www.cndba.cn/hbhe0316/article/108039

https://www.ibm.com/docs/en/idr/10.2.1?topic=server-ibmqrep-subs-table

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle