Home » Server Options » Replication » Materialized view refresh (Oracle 10g)
Materialized view refresh [message #282511] Thu, 22 November 2007 03:53 Go to next message
dileep_durani
Messages: 2
Registered: November 2007
Junior Member
Have some issue with Materialized view refresh
Have presented scenario which we have , need some help here

Schema1 :
1. Have base tables
2. Created MV logs on base tables

Schema2 :
1. Created sysnonyms for Schema1 base tables
2. created Materialized views
3. Created MV group , added views to the group

Executing the below command in schema2 :
execute dbms_refresh.refresh('MV_grp');

Error :
ORA-12048: error encountered while refreshing materialized view
"Schema2"."Table1_MV"
ORA-12018: following error encountered during code generation for
"Schema2"."Table1_MV
"ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1


Re: Materialized view refresh [message #282521 is a reply to message #282511] Thu, 22 November 2007 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You just forget to give the necessary privileges.

Regards
Michel
Re: Materialized view refresh [message #282555 is a reply to message #282521] Thu, 22 November 2007 06:10 Go to previous messageGo to next message
dileep_durani
Messages: 2
Registered: November 2007
Junior Member
Dear Martin
Thanks for response.

Not sure what privilages i have missed ,

can you provide some more details
Regards
Re: Materialized view refresh [message #282566 is a reply to message #282555] Thu, 22 November 2007 06:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Privilege to select, to create mview, to refresh mview.
Search on the doc.
For instance,
Database Advanced Replication
Chapter 3 Materialized View Concepts and Architecture
Section Materialized View Concepts
Subsection Required Privileges for Materialized View Operations

Regards
Michel
Re: Materialized view refresh [message #282598 is a reply to message #282566] Thu, 22 November 2007 08:18 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

http://babudba.blogspot.com/search/label/Replication
Re: Materialized view refresh [message #469103 is a reply to message #282555] Tue, 03 August 2010 06:10 Go to previous message
imrannsheikh
Messages: 1
Registered: January 2009
Location: Pune
Junior Member

Hye i 2 went through ths situation in my case i forgot to givr select grants on mview_log .. Laughing
Previous Topic: Lockheld in by In-doubt transaction
Next Topic: Question about Golden Gate replication tool
Goto Forum:
  


Current Time: Thu Mar 28 16:51:28 CDT 2024