Database Error Messages

ORA-14474

invalid usage of the modification to nonpartitioned state DDL

Cause

An attempt was made to use the modification to nonpartitioned state DDL with an unsupported condition. The ALTER TABLE MODIFY NONPARTITIONED DDL has the following restrictions:

  • A table must be partitioned.
  • Only heap tables are supported.
  • Tables cannot be reference partitioned or have any reference partitioned children.
  • A table cannot have any domain indexes or bitmap join indexes.

Action

Ensure that all of the conditions for the modification to nonpartitioned state DDL are satisfied.