ORA-1031 Creating an On Commit Materialized View on Another Schema
(Doc ID 433860.1)
Last updated on FEBRUARY 18, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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