) | hash_subpartition_quantity Defining subpartition templates by using theSUBPARTITION TEMPLATEkeywords is supported. The syntax in the template is the same as that of user-defined partitions. For more information, seeUser-defined partitions. Example: CREATE TABLE T (C1 DATE, C2 NUMBER)PARTITION B...
3、修改表子分区模板(Set Subpartition Template)下面举个例子: SUBPARTITION_NAME TABLESPACE_NAME H4 TBSPAR…sky13and23.blog.163.com|基于18个网页 2. 修改子分区模板属性 13. 修改子分区模板属性(set subpartition template)Alter table xxx set subpartition template (…);仅影响以后的子分区,当前的子...blo...
例如,以下创建了一个名为`emp_sub_template`的表,并使用`deptno`字段作为分区键,对其进行范围分区,并在每个范围内对`empname`字段进行哈希分区: ```sql CREATE TABLE emp_sub_template ( deptno NUMBER, emp... oracle表分区实例 ) PARTITION BY RANGE (credit_limit) SUBPARTITION BY LIST (nls_territory) ...
When you specify tablespace storage forthe subpartition template, it does not override any tablespace storage you havespecified explicitly for the partitions oftable. To specifytablespace storage for subpartitions, do one of these things: ·Omit tablespace storage at the partition level andspecify table...
This value can be specified in the subpartition template. INDEXINGVARCHAR2(4)NOIndicates whether the subpartition data is taken as a part of the indexes for each newly added composite partition in the subpartition template. Valid values:
EXCHANGE subpartition template s20240111 with table temp with validation; 数据校验说明 同官方一样,显式指定 WITH VALIDATION 来进行数据校验或者 WITHOUT VALIDATION 不进行数据校验。默认进行数据校验。 数据校验主要是验证 nt 表中一级分区的数据是否满足在 pt 表中对应一级分区下,二级分区的定义。在上面的示例中...
) PARTITION BY RANGE (iZoneAreaId) INTERVAL (100) SUBPARTITION BY RANGE (ilevel) SUBPARTITION TEMPLATE ( SUBPARTITION P1 VALUES LESS THAN (10) ) ( PARTITION part1 VALUES LESS THAN (100), PARTITION part2 VALUES LESS THAN (200) );
⼦分区：Set Template, Modify, Move, Drop, Rename, Truncate, Split, Merge, Exchange Move: 将分区、⼦分区移动到新的表空间。Coalesce: 只适⽤于 hash 分区的表。作⽤是减少⼀个 hash 分区；⽅法是将最后⼀个分区的数据分布到前⾯的分区中，再删除此分区。 Merge: 将两个分区、⼦分区...
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4 @@ -1264,6 +1264,7 @@ alterTablePartitioning : modifyTableDefaultAttrs | setSubpartitionTemplate | modifyTablePartition + | modifyTableSubpartition | moveTablePartition ...
SUBPARTITION TEMPLATE (SUBPARTITION east VALUES ('CHINA', 'JAPAN', 'INDIA', 'THAILAND'), SUBPARTITION west VALUES ('AMERICA', 'GERMANY', 'ITALY', 'SWITZERLAND'), SUBPARTITION other VALUES (DEFAULT)) (PARTITION p1 VALUES LESS THAN (1000), ...