Home » Server Options » Replication » cannot fast refresh turncated MV even after complete refresh (Oracle 10.2.0.4 64bit)
cannot fast refresh turncated MV even after complete refresh [message #471434] Sat, 14 August 2010 09:35 Go to next message
spur230
Messages: 25
Registered: April 2009
Location: US
Junior Member
I am getting ORA -32320 when I tried to fast fresh MVs that were truncated.I am able to complete refresh all MVs. However, some MVs are still giving me ORA-32320 when I try to do fast refresh even after complete refresh.

DBMS_MVIEW.EXPLAIN_PLAN says the MVIEW can be fast refreshed.

ERROR at line 1:
ORA-32320: REFRESH FAST of "dev"."Claim_line" 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


Quote:
ORA-32320:
REFRESH FAST of "string"."string" 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.


Kindly suggest how to again make the MVs fast refreshable?

[Updated on: Sat, 14 August 2010 10:43] by Moderator

Report message to a moderator

Re: cannot fast refresh turncated MV even after complete refresh [message #471444 is a reply to message #471434] Sat, 14 August 2010 10:44 Go to previous messageGo to next message
Michel Cadot
Messages: 67135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ You can determine why your materialized view does not support fast refresh after PMOPs using the DBMS_MVIEW.EXPLAIN_MVIEW() API.

2/ Recreate them.

Regards
Michel

[Updated on: Sat, 14 August 2010 10:45]

Report message to a moderator

Re: cannot fast refresh truncated MV even after complete refresh [message #471451 is a reply to message #471444] Sat, 14 August 2010 11:12 Go to previous messageGo to next message
spur230
Messages: 25
Registered: April 2009
Location: US
Junior Member
Thank you for your response.

DBMS_MVIEW.EXPLAIN_MVIEW() says its fast refreshable.

Yes recreating them seem to work but isn't it possible to fix them with out recreating.

Like I said I was able to fast refresh some truncated MV after complete refresh.
Re: cannot fast refresh truncated MV even after complete refresh [message #471452 is a reply to message #471451] Sat, 14 August 2010 11:15 Go to previous messageGo to next message
Michel Cadot
Messages: 67135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
These "some truncated MV" are maybe not partitioned?

Regards
Michel

[Updated on: Sat, 14 August 2010 11:15]

Report message to a moderator

Re: cannot fast refresh truncated MV even after complete refresh [message #471455 is a reply to message #471452] Sat, 14 August 2010 11:19 Go to previous message
spur230
Messages: 25
Registered: April 2009
Location: US
Junior Member
None of them are partitioned.
Previous Topic: Question about Golden Gate replication tool
Next Topic: Bi-Directional Replication through Golden Gate
Goto Forum:
  


Current Time: Fri May 29 09:50:44 CDT 2020