This topic describes the conversion scope of ALTER TABLE DDL operations for adding partitions and subpartitions during data migration from an Oracle database to the Oracle compatible mode of OceanBase Database.
Syntax
add_table_partition:
ADD {
PARTITION [ partition ] add_range_partition_clause
[, PARTITION [ partition ] add_range_partition_clause ]...
| PARTITION [ partition ] add_list_partition_clause
[, PARTITION [ partition ] add_list_partition_clause ]...
| PARTITION [ partition ] add_system_partition_clause
[, PARTITION [ partition ] add_system_partition_clause ]...
[ BEFORE { partition_name | partition_number } ]
| PARTITION [ partition ] add_hash_partition_clause
} [ dependent_tables_clause ]
add_range_partition_clause:
range_values_clause
[ table_partition_description ]
[ external_part_subpart_data_props ]
[ ( { range_subpartition_desc [, range_subpartition_desc] ...
| list_subpartition_desc [, list_subpartition_desc] ...
| individual_hash_subparts [, individual_hash_subparts] ...
}
) | hash_subparts_by_quantity ]
[ update_index_clauses ]
add_list_partition_clause:
list_values_clause
[ table_partition_description ]
[ external_part_subpart_data_props ]
[ ( { range_subpartition_desc [, range_subpartition_desc] ...
| list_subpartition_desc [, list_subpartition_desc] ...
| individual_hash_subparts [, individual_hash_subparts] ...
}
) | hash_subparts_by_quantity ]
[ update_index_clauses ]
add_system_partition_clause:
[table_partition_description]
[update_index_clauses]
add_hash_partition_clause:
partitioning_storage_clause
[ update_index_clauses ]
[ parallel_clause ]
[ read_only_clause ]
[ indexing_clause ]
dependent_tables_clause:
DEPENDENT TABLES
( table ( partition_spec [, partition_spec]...
[, table ( partition_spec [, partition_spec]... )]
)
)
Supported operations
Adding LIST and RANGE partitions is supported.
Adding LIST and RANGE subpartitions is supported.
Unsupported operations
Adding HASH partitions is not supported.
Adding HASH subpartitions is not supported.
Adding SYSTEM partitions is not supported. An error will be returned when you perform this operation.
Ignored clauses and options
Note
The following clauses and options will be ignored and will not be resolved or converted when they are specified in the synchronized DDL statements.
The
dependent_tables_clauseclause for specifying partition attributes.The
update_index_clausesclause for updating indexes in the table.