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

ORA-24335: cannot support more than 1000 columns

1 Answers  


RMAN-06734: Do you really want to drop all backups and the database (enter YES or NO)?

1 Answers  


ORA-16159: Cannot change protected standby destination attributes

1 Answers  


ORA-01156: recovery in progress may need access to files

2 Answers  


ORA-32318: cannot rename a materialized view

1 Answers  






TNS-01041: %s parameter "string" set to string

1 Answers  


ORA-00288: to continue recovery type ALTER DATABASE RECOVER CONTINUE

1 Answers  


NNL-00808: Queries received, all user-defined types: number

1 Answers  


ORA-00398: abort thread recovery due to reconfiguration

1 Answers  


ORA-01031: insufficient privileges

1 Answers  


ORA-08004: sequence string.NEXTVAL string stringVALUE and cannot be instantiated

1 Answers  


ORA-01687: specified logging attribute for tablespace 'string' is same as the existing

1 Answers  


Categories