ORA-1031 Creating an On Commit Materialized View on Another Schema
Last updated on JUNE 08, 2015
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
In a secure environment with a restricted access to schemas and privileges, where:
Base tables are owned by schema A.
Materialized views must be owned by schema B.
An external group is accessing with the schema C.
If schema C needs to create a local on commit materialized view under schema B, which references tables on schema A, the create materialized view may fail with error ORA-1031 (insufficient privileges).
Executing as C:
This statement does not fail if the create materialized view is executed as user B.
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