Cause
Offline instantiation does not support materialized views using the following options: o ON PREBUILT TABLE o BUILD DEFERRED
Action
Remove the invalid options.
Oracle 26ai
ORA-12070
Error Message
cannot offline instantiate materialized view "string"."string"