Erro perforing Fast Refresh of Materialized View. [message #345820] |
Thu, 04 September 2008 22:50 |
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 #345836 is a reply to message #345821] |
Fri, 05 September 2008 00:40 |
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,
|
|
|
|
|