Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-22817: subquery not allowed in the default clause

1 Answers  


ORA-02475: maximum cluster chain block count of string has been exceeded

1 Answers  


NNL-00529: set|show default_domain [<domain_name>] : set|show the current default domain

1 Answers  


RMAN-03033: current log archived

1 Answers  


PROC-00009: Cannot perform cluster registry operation because the buffer passed is too small.

1 Answers  






ORA-32740: The requested operation cannot be proceeded

1 Answers  


ORA-25137: Data value out of range

1 Answers  


ORA-00297: must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START

1 Answers  


ORA-09858: sfngat: the input file name is not in the OMF format

1 Answers  


ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

1 Answers  


PLS-00328: A subprogram body must be defined for the forward declaration of string.

1 Answers  


DGM-16946: Site "string" was not found

1 Answers  






Categories