请问大家，单表和分区表，都可以设定为复制表吗

[起飞咯das]

麻烦问下大家，单表和分区表，都可以设定为复制表吗，求大佬解答

[木芯心]

可以的，复制表就是副本强一致性，跟是什么表没关系
https://open.oceanbase.com/docs/tutorials-cn/V1.0.0/10000000000012318

[AntTech_DH4OV0]

请问创建复制表的语句怎么写呀？oceanbase版本 5.7.25-OceanBase_CE-v4.1.0.0。用原来的语句报错。mysql> CREATE TABLE CUSTOMER (
→ C_CUSTKEY INTEGER NOT NULL,
→ C_NAME VARCHAR(25) NOT NULL,
→ C_ADDRESS VARCHAR(40) NOT NULL,
→ C_NATIONKEY INTEGER NOT NULL,
→ C_PHONE CHAR(15) NOT NULL,
→ C_ACCTBAL DECIMAL(15,2) NOT NULL,
→ C_MKTSEGMENT CHAR(10) NOT NULL,
→ C_COMMENT VARCHAR(117) NOT NULL)
→ DUPLICATE SCHEMA = ‘cluster’;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘DUPLICATE SCHEMA = ‘cluster’’ at line 10

[和顺]

OB 4.1里目前不支持复制表，在OB4.2版本会支持。