ORA-32349, or ORA-1031 When Creating Materialized View and OPTIMIZER_SECURE_VIEW_MERGING = TRUE

(Doc ID 1469849.1)

Last updated on JULY 31, 2012

Applies to:

Oracle Server - Enterprise Edition - Version and later
Information in this document applies to any platform.


 While trying to create a materialized view on a prebuilt table, you receive one of these errors:

ERROR at line 1:
ORA-32349: cannot reference prebuilt table in definition query for materialized view

ERROR at line 1:
ORA-01031: insufficient privileges


You have checked that the schema owner creating the materialized view meets the prerequisites for creating materialized views.



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms