Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Refresh materialized view in another user's schema

Status
Not open for further replies.

JtheRipper

IS-IT--Management
Oct 4, 2002
274
GB
Hi there,

I want to do a complete refresh of a MV in another user's schema. I have the following privileges granted to me:
Code:
DBA
CONNECT
DW_USER
DEV_USER
RESOURCE

ANALYZE ANY
CREATE TABLE
DROP ANY VIEW
CREATE SESSION
ALTER ANY INDEX
ALTER ANY TABLE
CREATE ANY VIEW
CREATE SNAPSHOT
CREATE ANY TABLE
SELECT ANY TABLE
DROP ANY SNAPSHOT
ALTER ANY SNAPSHOT
CREATE ANY SNAPSHOT
GLOBAL QUERY REWRITE
UNLIMITED TABLESPACE

PRIVILEGE
----------------------------------------
SELECT
REFERENCES
ALTER

When I execute the following command I get:
SQL> exec dbms_mview.refresh('ITEM_DIM','C');
BEGIN dbms_mview.refresh('ITEM_DIM','C'); END;

*
ERROR at line 1:
ORA-12018: following error encountered during code generation for
"ITEM_DIM"
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 832
ORA-06512: at line 1

Any ideas?

Thanks,
J.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top