Oracle Error QSM-03115: Cannot tune materialized view ON PREBUILT table

Oracle Error Message

QSM-03115: Cannot tune materialized view ON PREBUILT table

Reason for the Error

The materialized view was created on a prebuilt table.

Solution

Rephrase the statement to avoid the use of the ON PREBUILT option.