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

RMAN-03032: this option of set command needs to be used outside of a run block

1 Answers  


RMAN-06727: could not locate datafilecopy string

1 Answers  


ORA-31459: system triggers for DBMS_CDC_PUBLISH package are not installed

1 Answers  


PCC-00082: Length and scale specifications must be an integer

1 Answers  


ORA-29533: attempt to overwrite class or resource string while defining or compiling string.string

1 Answers  






LPX-00018: internal error "nested open strings"

1 Answers  


ORA-00131: network protocol does not support registration 'string'

1 Answers  


PLS-00143: duplicate external LANGUAGE specification in subprogram expression

1 Answers  


ORA-12819: missing options in PARALLEL clause

1 Answers  


ORA-25281: complete reciever information not provided to non-repudiate reciever

1 Answers  


PLS-01424: Non-ANSI order of clauses

1 Answers  


ORA-00091: LARGE_POOL_SIZE must be at least string

1 Answers  


Categories