My Oracle Support Banner

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 9.2.0.6 and later
Information in this document applies to any platform.

Symptoms

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.

Cause

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
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.