Oracle DBA, How To, Error, Cause and Action

ORA-12070: cannot offline instantiate materialized view string.string

ORA-12070: cannot offline instantiate materialized view "string"."string"


Cause:


Offline instantiation does not support materialized views using the following options:
* ON PREBUILT TABLE
* BUILD DEFERRED



Action:


Remove the invalid options.

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)