ORA-32340: cannot tune the materialized view definition



ORA-32340: cannot tune the materialized view definition..

Answer / guest

Cause: Due to constructs in the materialized view
definition, it could not be tuned to be fast-refreshable or
rewriteable.

Action: Execute DBMS_MVIEW.EXPLAIN_MVIEW to determine the cause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28272: Domain policy restricts password based GLOBAL user authentication.

1 Answers  


NNO-00322: statistic counter dump interval changed to number seconds

1 Answers  


ORA-31439: subscription is already active

1 Answers  


DRG-11703: user string must have at least CTXAPP role to execute this function

1 Answers  


ORA-07498: spstp: Unable to open /dev/resched.

1 Answers  






DRG-12217: tags cannot be more than 64 bytes

1 Answers  


ORA-25268: didnt dequeue in browse mode with get signature option

1 Answers  


ORA-16199: Terminal recovery failed to recover to a consistent point

1 Answers  


ORA-30743: "string" is not an object view

1 Answers  


ORA-26506: null global context

1 Answers  


PCB-00313: TO SAVEPOINT clause is an Oracle extension

1 Answers  


TNS-12209: TNS:encountered uninitialized global

1 Answers  


Categories