Thursday, September 9, 2010

Creating materialized view in other schema reports error ORA-01031

While creating materialized view in other schema reports error ORA-01031.

The user you are using has the SELECT ANY TABLE,CREATE MATERIALIZED VIEW,CREATE ANY VIEW,CREATE ANY MATERIALIZED VIEW,CREATE ANY TABLE,CREATE SESSION.

This is due a bug. Grant explicitly the create table privilege to the user has the tables the materialized view relies.

Metalink Note Id: 749112.1

No comments:

Post a Comment