Drop a subpartition

This topic describes the supported conversion scope of ALTER TABLE DDL operations for dropping a subpartition during data migration from an Oracle database to the Oracle compatible mode of OceanBase Database.

Syntax

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

• Dropping a specified subpartition by name is supported. Example:

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

• Updating global indexes by using the UPDATE GLOBAL INDEXES clause is supported.

Unsupported operations

• Dropping a subpartition by specifying the subpartition key value is not supported.

• The INVALIDATE GLOBAL INDEXES clause is not supported and will be converted to the UPDATE GLOBAL INDEXES clause.

Ignored clauses and options

• The update_all_indexes_clause clause for updating indexes in a table.

• The parallel_clause clause for modifying the default query and DML parallelism in a table.