Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-14253

table is not partitioned by composite partition method

Cause

One of the following occurred:

  • The table in a subpartition maintenance operation (ALTER TABLE [EXCHANGE | MODIFY | MOVE | TRUNCATE] SUBPARTITION or ALTER TABLE MODIFY PARTITION [ADD | COALESCE] SUBPARTITION) was not partitioned by the composite partition method.
  • The table in the MODIFY DEFAULT ATTRIBUTES FOR PARTITION operation was partitioned by a method other than the composite method.
  • The table in the ALTER TABLE MODIFY SUBPARTITION [UNUSABLE LOCAL INDEXES | REBUILD UNUSABLE LOCAL INDEXES] statement was not partitioned by the composite partition method which is illegal.

Action

Ensure that the table is partitioned by composite partition method.