Oracle Error Message
ORA-12070: cannot offline instantiate materialized view “string”.”string”
Reason for the Error
Offline instantiation does not support materialized views using the following options:
o ON PREBUILT TABLE
o BUILD DEFERRED
Solution
Remove the invalid options.