ORA-1031 Creating an On Commit Materialized View on Another Schema (Doc ID 433860.1)

Last updated on JUNE 08, 2015

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

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