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-07681: sou2os: An error occurred while initializing Oracle

1 Answers  


RMAN-08033: channel string: including datafilecopy of datafile string in backupset

1 Answers  


ORA-24351: invalid date passed into OCI call

1 Answers  


ORA-25006: cannot specify this column in UPDATE OF clause

1 Answers  


RMAN-12010: automatic channel allocation initialization failed

1 Answers  






ORA-23306: schema string does not exist

1 Answers  


ORA-38775: cannot disable flash recovery area - flashback database is enabled

2 Answers  


ORA-07598: spwat: $SETIMR failure

1 Answers  


ORA-01129: user's default or temporary tablespace does not exist

1 Answers  


ORA-13639: The current operation was interrupted because it timed out.

1 Answers  


PLS-00355: use of pl/sql table not allowed in this context

1 Answers  


SQL*Loader-00123: specified value for bindsize(number) less than readsize(number)

1 Answers  


Categories