Home » Server Options » Replication » Materialized View Issue
Materialized View Issue [message #32472] Thu, 19 August 2004 05:44 Go to next message
Messages: 16
Registered: November 2002
Junior Member
When I tried to create a materialized view on the table which I created, I am getting the following error message. I am positive that I do have full access on that table. Can any one throw some light here? Any help is greatly appreciated!

The following error has occurred:

ORA-01031: insufficient privileges
Re: Materialized View Issue [message #32475 is a reply to message #32472] Thu, 19 August 2004 06:52 Go to previous message
Messages: 98
Registered: November 2003
Found on the Oracle 9.2 Documentation:

To create a materialized view in your own schema:

You must have been granted the CREATE MATERIALIZED VIEW system privilege and either the CREATE TABLE or CREATE ANY TABLE system privilege.
You must also have access to any master tables of the materialized view that you do not own, either through a SELECT object privilege on each of the tables or through the SELECT ANY TABLE system privilege.
Previous Topic: how to refresh snapshot and materized views?
Next Topic: Materized View linking with Muliple Sites or DBs
Goto Forum:

Current Time: Fri Apr 10 03:08:54 CDT 2020