Drop subpartitions

This topic describes the conversion scope of ALTER TABLE DDL operations for dropping subpartitions when you migrate data from an Oracle database to an Oracle compatible mode of OceanBase Database.

Overview

drop_table_subpartition:
DROP subpartition_extended_names
  [ update_index_clauses [ parallel_clause ] ]

subpartition_extended_names:
{ SUBPARTITION | SUBPARTITIONS }
subpartition | { FOR ( subpartition_key_value [, subpartition_key_value ]... ) }
  [, subpartition | { FOR ( subpartition_key_value [, subpartition_key_value ]... ) } ]...

Supported operations

• You can drop a subpartition by specifying the name of the subpartition. Example:

  ALTER TABLE T DROP SUBPARTITION SP0,SP1
  ALTER TABLE T DROP SUBPARTITIONS SP0,SP1
  

• You can use the UPDATE GLOBAL INDEXES clause to update indexes in the table.

Unsupported operations

• You cannot drop a subpartition by specifying the subpartition key values.

• You cannot use the INVALIDATE GLOBAL INDEXES clause. It will be converted to the UPDATE GLOBAL INDEXES clause.

Ignored clauses and options

• The update_all_indexes_clause clause for updating indexes in the table.

• The parallel_clause clause for modifying the default degree of parallelism for queries and DML operations in the table.