OceanBase 支持最大的单表是多大？pctfree最大多少？

ob支持最大的单表是多大？

obclient> CREATE TABLE t1_big (
->   "OWNER" VARCHAR2(128) DEFAULT NULL NOT NULL,
->   "OBJECT_NAME" VARCHAR2(128),                                                                    
-> ) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 524288 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 8109999999999999990 PCTFREE = 10;
ERROR-00600: internal error code, arguments: -4147, Invalid config
obclient> CREATE TABLE t1_big (
->   "OWNER" VARCHAR2(128) DEFAULT NULL NOT NULL,
->   "OBJECT_NAME" VARCHAR2(128),                                                                    
-> ) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 524288 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 8053063680000000000 PCTFREE = 10;
Query OK, 0 rows affected (0.05 sec)
obclient> select 8053063680000000000/1024/1024/1024/1024/1024 "PB" from dual;
+-------------------+
| PB                |
+-------------------+
| 7152.557373046875 |
+-------------------+
1 row in set (0.00 sec)

我简单算了一下，单表最大支持大概是7 PB左右。 也足够海量了。。。。

表参数属性跟Oracle类似吗？ 大家知道Oracle table pctfree最大可以是99，那么ob呢 ？

obclient> CREATE TABLE t1_big (
->   "OWNER" VARCHAR2(128) DEFAULT NULL NOT NULL,
->   "OBJECT_NAME" VARCHAR2(128),
-> ) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 32768 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 50;
ERROR-02211: invalid value for PCTFREE or PCTUSED
obclient> CREATE TABLE t1_big (
->   "OWNER" VARCHAR2(128) DEFAULT NULL NOT NULL,
->   "OBJECT_NAME" VARCHAR2(128),
-> ) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 32768 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 49;
Query OK, 0 rows affected (0.04 sec)
obclient> 
obclient>  CREATE TABLE t1_big (
->   "OWNER" VARCHAR2(128) DEFAULT NULL NOT NULL,
->   "OBJECT_NAME" VARCHAR2(128),
-> ) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 32768 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728  PCTUSED= 40;
ERROR-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near '= 40' at line 4

从测试可以看出ob2.2版本的Oracle租户模式下，pctfree最大是49。 而且ob不支持pctused参数。