Database Error Messages

OCI-60302

Partition maintenance operation cannot affect more than maximum_affected_partitions partitions in presence of local domain indexes.
  • maximum_affected_partitions: The maximum number of affected partitions allowed for a partition maintenance operation on a table having a local domain index.

Cause

An invalid number of partitions were specified for a partition maintenance operation. A partition maintenance operation can only affect a maximum number of partitions when there is a local domain index on the table:

  • One partition or subpartition for ADD PARTITION or ADD SUBPARTITION.
  • One partition or subpartition for DROP PARTITION or DROP SUBPARTITION.
  • One partition or subpartition for TRUNCATE PARTITION or TRUNCATE SUBPARTITION.
  • Two source partitions or subpartitions for MERGE PARTITION or MERGE SUBPARTITION.
  • Two target partitions or subpartitions for SPLIT PARTITION or SPLIT SUBPARTITION.

Action

Modify the partition maintenance operation to affect only the allowed number of partitions or subpartitions, and then retry the statement.