Home » Server Options » Replication » Erro perforing Fast Refresh of Materialized View. (Oracle)
Erro perforing Fast Refresh of Materialized View. [message #345820] Thu, 04 September 2008 22:50 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Hi Experts,

We are facing serious problem while refreshing materialized
views using fast refresh option in ORACLE..
For the very first time we are performing Complete refresh of
data from DB1 to DB2 for few tables.Ongoing we are performing Fast Refresh.
Sometimes the fast refresh works fine without any error and
sometimes it fails with the below error.

ERROR at line 1:
ORA-32320: REFRESH FAST of "CIR"."C_BO_COMM" unsupported after 
cointainer table
PMOPs
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 841
ORA-06512: at line 1
 


Please let me know when will this error occur during Fast
Refresh.
Appreicate your earliest reply.

Thank you.
Re: Erro perforing Fast Refresh of Materialized View. [message #345821 is a reply to message #345820] Thu, 04 September 2008 22:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Quote:

32320, 00000, "REFRESH FAST of \"%s\".\"%s\" unsupported after container table PMOPs"
// *Cause: A Partition Maintenance Operation (PMOP) has been performed on the
// materialized view, and no materialized view supports
// fast refersh after container table PMOPs.
// *Action: Use REFRESH COMPLETE. Note: you can determine why your
// materialized view does not support fast refresh after PMOPs using
// the DBMS_MVIEW.EXPLAIN_MVIEW() API.

Re: Erro perforing Fast Refresh of Materialized View. [message #345836 is a reply to message #345821] Fri, 05 September 2008 00:40 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Anacedent,

Thanks for the response.

The Cause and Error we also came to know. Please let u know
what action to be taken to avoid this.

Please note that this error is not repeated always. Some times
REFRESH FAST is happening and some times it is throwing error.

Thank you,



Re: Erro perforing Fast Refresh of Materialized View. [message #345860 is a reply to message #345836] Fri, 05 September 2008 02:40 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello,

Confirm me; you done any DDL
(ALTER TABLE t_name ADD/MODIFY...)
changes in your base table?

Babu
Re: Erro perforing Fast Refresh of Materialized View. [message #345861 is a reply to message #345821] Fri, 05 September 2008 02:40 Go to previous message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Please find the attached Explain Plan.
  • Attachment: error.txt
    (Size: 54.60KB, Downloaded 2239 times)
Previous Topic: Data Synchronization Issue
Next Topic: Advanced Replication, Oracle Streams what is best option
Goto Forum:
  


Current Time: Thu Mar 28 19:42:10 CDT 2024