Overview

This topic describes the conversion scope of CREATE TABLE DDL operations for partition synchronization during data migration from an Oracle database to an Oracle-compatible tenant of OceanBase Database.

Syntax

{ range_partitions
| list_partitions
| hash_partitions
| composite_range_partitions
| composite_list_partitions
| composite_hash_partitions
| reference_partitioning
| system_partitioning
| consistent_hash_partitions
| consistent_hash_with_subpartitions
| partitionset_clauses
}

reference_partitioning:
PARTITION BY REFERENCE ( constraint )
  [ (reference_partition_desc...) ]

system_partitioning:
PARTITION BY SYSTEM [ PARTITIONS integer
                    | reference_partition_desc
                       [, reference_partition_desc ...]
                    ]

consistent_hash_partitions:
PARTITION BY CONSISTENT HASH (column [, column ]...)
  [ PARTITIONS AUTO ] TABLESPACE SET tablespace_set

consistent_hash_with_subpartitions:
PARTITION BY CONSISTENT HASH (column [, column ]...)
  { subpartition_by_range
  | subpartition_by_list
  | subpartition_by_hash
  }
  [ PARTITIONS AUTO ]

partitionset_clauses:
{ range_partitionset_clause | list_partitionset_clause }

Supported operations

• Defining RANGE partitions by using the range_partitions option is supported. For more information, see RANGE partitioning.

• Defining LIST partitions by using the list_partitions option is supported. For more information, see LIST partitioning.

• Defining HASH partitions by using the hash_partitions option is supported. For more information, see HASH partitioning.

• Defining RANGE subpartitions by using the composite_range_partitions option is supported. For more information, see RANGE subpartitioning.

• Defining LIST subpartitions by using the composite_list_partitions option is supported. For more information, see LIST subpartitioning.

• Defining HASH subpartitions by using the composite_hash_partitions option is supported. For more information, see HASH subpartitioning.

Unsupported operations

• Defining REFERENCE partitions by using the reference_partitioning option is not supported. An error will be returned when you perform this operation.

• Defining SYSTEM partitions by using the system_partitioning option is not supported. An error will be returned when you perform this operation.

• Creating consistent HASH partitions by using the consistent_hash_partitions option is not supported. An error will be returned when you use this option on non-sharded tables.

• Creating HASH partitions consistent with subpartitions by using the consistent_hash_with_subpartitions option is not supported. An error will be returned when you use this option on non-sharded tables.

• Creating RANGE and LIST partition sets by using the partitionset_clauses clause is not supported. An error will be returned when you perform these operations.