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


QSM-02123: subquery and UNION mv's must be primary key mv's



QSM-02123: subquery and UNION mv's must be primary key mv's..

Answer / guest

Cause: The capability in question is not supported when the
materialized view is not a primary key materialized view and
uses subqueries or the union operator in this context.

Action: Re-create the materialized view as 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-25330: PL/SQL associative arrays may not be used with AQ array operations

1 Answers  


TNS-12230: TNS:Severe Network error occurred in making this connection

1 Answers  


TNS-00207: Uptime : number days number hr. number min. number sec

1 Answers  


ORA-12490: DBHIGH cannot be lowered

1 Answers  


RMAN-06413: channel string does not support proxy copy

1 Answers  






PLS-00208: identifier 'string' is not a legal cursor attribute

1 Answers  


ORA-12671: Shared server: adapter failed to save context

1 Answers  


TNS-12597: TNS:connect descriptor already in use

1 Answers  


ORA-02211: invalid value for PCTFREE or PCTUSED

1 Answers  


ORA-16614: object has an ancestor that is disabled

1 Answers  


TNS-04017: Please wait. Shutdown in progress.

1 Answers  


ORA-25441: duplicate column value for table alias: string

1 Answers  






Categories