ORA-32320: REFRESH FAST of "string"."string" unsupported
after container table PMOPs

Answers were Sorted based on User's Feedback



ORA-32320: REFRESH FAST of "string"."string" unsupported after container table ..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

ORA-32320: REFRESH FAST of "string"."string" unsupported after container table ..

Answer / mahesh

If the Table is not a Partitioned one then also it is
throwing the same exception.

How is this possible.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16064: remote archival is disabled by another instance

1 Answers  


TNS-00046: INTCTL: Could not contact the CMANAGER on address

1 Answers  


NNL-01040: Data streams opened by server: number

1 Answers  


PCC-02431: Expecting an expression of type external LOB (BFILE)

1 Answers  


DGM-16960: status not available

1 Answers  


QSM-01610: a lossy join in equivalence, string, between tables, string, not found in query

1 Answers  


EXP-00091: Exporting questionable statistics.

1 Answers  


IMG-02005: 2FF05 - incorrect color specification

1 Answers  


ORA-16160: Cannot change protected standby database configuration

1 Answers  


RMAN-03013: Copyright (c) 1995, 2003, Oracle Corporation. All rights reserved.

1 Answers  


DRG-50608: unexpected end of data

1 Answers  


ORA-12060: shape of prebuilt table does not match definition query

1 Answers  


Categories