ORA-32337: cannot alter materialized view with pending
changes refresh on commit



ORA-32337: cannot alter materialized view with pending changes refresh on commit..

Answer / guest

Cause: There are some pending changes in the detail tables

Action: Execute an on-demand refresh on the materialized
view to synchronize the data between the materialized view
and the detail tables and then issue an ALTER MATERIALIZED
VIEW statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-12566: TNS:protocol error

1 Answers  


RMAN-06079: database must be mounted to perform recovery

1 Answers  


ORA-31460: logfile location string is not an existing directory

1 Answers  


ORA-16505: site ID is invalid

1 Answers  


ORA-07245: sfccf: unable to lseek and write the last block.

1 Answers  






PCC-02309: illegal formal parameter declaration

1 Answers  


ORA-39048: Unable to start all workers; only string worker(s) available.

1 Answers  


NNL-00540: [show] status [<server_list>] : display server status summary

1 Answers  


ORA-13863: Statistics aggregation for service(module/action) string is not enabled

1 Answers  


ORA-02285: duplicate START WITH specifications

1 Answers  


NNL-00210: Cache checkpointing is currently disabled

1 Answers  


ORA-32584: missing LOG keyword

1 Answers  


Categories