QSM-02073: non-primary key RepAPI mv is not fast refreshable



QSM-02073: non-primary key RepAPI mv is not fast refreshable..

Answer / guest

Cause: Fast refresh is supported for RepAPI materialized
views only if it is also a primary key materialized view.

Action: Re-design the materialized view to be a primary key
materialized view.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12650: No common encryption or data integrity algorithm

1 Answers  


ORA-33060: (XSAGDNGL29) In AGGMAP workspace object, the value for the ERRORLOG MAX option must be greater than 0.

1 Answers  


TNS-04234: Trace Assistant WARNING: won't decode TTC

1 Answers  


PLS-00406: length of SELECT list in subquery must match number of assignment targets

1 Answers  


NMP-00007: I/O failure

1 Answers  






ORA-37072: (XSMCSESS00) Object workspace object has the wrong type.

1 Answers  


PCC-00045: %s clause inappropriate at line number in file string. Ignored.

1 Answers  


ORA-30484: missing window specification for this function

1 Answers  


ORA-14150: missing SUBPARTITION keyword

1 Answers  


TNS-00108: TNS_ADMIN not defined

1 Answers  


PCC-02311: cannot have VARCHAR bit fields

1 Answers  


ORA-00371: not enough shared pool memory, should be atleast string bytes

1 Answers  


Categories