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-13605: The specified task or object string does not exist for the current user.

1 Answers  


PCC-02303: cannot open include file

1 Answers  


ORA-39027: wrong version of master table

1 Answers  


ORA-31463: logfile location string is an empty directory

1 Answers  


ORA-27371: jobs of type EXECUTABLE are not supported on this platform

1 Answers  






ORA-08444: syntax error in JUSTIFIED clause in mask options

1 Answers  


ORA-09786: sllfop: open error, unable to open file.

1 Answers  


NID-00106: LOGIN to target database failed with Oracle error: string

1 Answers  


ORA-34000: (MODCOMP13) You cannot use both workspace object and workspace object as model dimensions, because they are both surrogates of dimension workspace object.

1 Answers  


QSM-02176: MV with UNION ALL in a view is too complex

1 Answers  


RMAN-06074: file string is not an ORACLE datafile

1 Answers  


ORA-02284: duplicate INCREMENT BY specifications

1 Answers  


Categories