哪位大哥幫忙講解一下建表時,data capture none是什么意思?

daliwa

哪位大哥幫忙講解一下建表時,data capture none是什么意思?
謝謝!

huyuhui001

是對使用數(shù)據(jù)復(fù)制的Capture進程使用的。用來捕捉這個table的sql變化，記入log，以同步目標table。

daliwa

那么data capture none的意思,就是這個表不用做同步了?
不知你有沒同步的經(jīng)驗?
能大概說明一下怎么實現(xiàn)庫的同步嗎?
或是給點資料的鏈接也行
謝謝

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.

復(fù)制代碼