merging partitions or subpartitions using <name> TO <name> syntax is only supported for range partitioned tables

Solution ID:ORA-14807

Type: Oracle

Cause

An ALTER TABLE MERGE PARTITIONS <pname> TO <pname> or an ALTER TABLE MERGE SUBPARTITIONS <subpname> TO <subpname> was issued. This is only supported for range partitions or subpartitions.

Actions

Specify at least 2 resulting partitions.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/3229900


Browse all solutions to database errors from Oracle, MS SQL, or MySQL