哪位大哥帮忙讲解一下建表时,data capture none是什么意思?

daliwa

哪位大哥帮忙讲解一下建表时,data capture none是什么意思?
谢谢!

huyuhui001

是对使用数据复制的Capture进程使用的。用来捕捉这个table的sql变化，记入log，以同步目标table。

daliwa

那么data capture none的意思,就是这个表不用做同步了?
不知你有没同步的经验?
能大概说明一下怎么实现库的同步吗?
或是给点资料的链接也行
谢谢

huyuhui001

db2e0e80-Replication Guide and Reference.pdf
看这本书

daliwa

3ks

mymm

1. DATA CAPTURE
   
2. Indicates whether extra information for inter-database data replication is to be written to the log. This clause cannot be specified when creating a subtable (SQLSTATE 42613).
   
3. If the table is a typed table, then this option is not supported (SQLSTATE 428DH or 42HDR).
   
4. 
   
5. 
   
6. NONE
   
7.         Indicates that no extra information will be logged.
   
8. 
   
9. CHANGES
   
10.         Indicates that extra information regarding SQL changes to this table will be written to the log. This option is required if this table will be replicated and the Capture program is used to capture changes for this table from the log.
    
11. If the table is defined to allow data on a partition other than the catalog partition (multiple partition nodegroup or nodegroup with a partition other than the catalog partition), then this option is not supported (SQLSTATE 42997).
    
12. 
    
13. If the schema name (implicit or explicit) of the table is longer than 18 bytes, then this option is not supported (SQLSTATE 42997).
    
14. 
    
15. Further information about using replication can be found in the Administration Guide and the Replication Guide and Reference.

复制代码