Oracle Error QSM-02070: PCT not supported with this type of partitioning

Oracle Error Message

QSM-02070: PCT not supported with this type of partitioning

Reason for the Error

The capability in question is not supported when the table in question uses certain types of partitioning.

Solution

Re-phrase the query to reference a table that is uses a type of partitioning that is supported for this capability.