Oracle Error QSM-01111: no partition key or partition marker found in MV, string

Oracle Error Message

QSM-01111: no partition key or partition marker found in MV, string

Reason for the Error

In order to do query rewrite with fresh partitions of an MV, the MV should have a partiton key or partition marker.

Solution

None