ORA-1031 Creating an On Commit Materialized View on Another Schema
(Doc ID 433860.1)
Last updated on AUGUST 04, 2018
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document