ORA-12036: updatable materialized view log is not empty,
refresh materialized view



ORA-12036: updatable materialized view log is not empty, refresh materialized view..

Answer / guest

Cause: The updatable materialized view log was not empty.
The updatable materialized view log must be empty before an
updatable rowid materialized view can be altered to a
primary key materialized view.

Action: Ensure that updatable materialized view log is empty
by refreshing the materialized view before converting the
updatable ROWID materialized view to 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-26054: Direct Path Context prepared for a different mode than operation requested.

1 Answers  


PLS-00364: loop index variable 'string' use is invalid

1 Answers  


DRG-52207: the specified attribute does not exist: string

1 Answers  


ORA-01175: data dictionary has more than the string files allowed by the instance

1 Answers  


ORA-15056: additional error message

1 Answers  






ORA-19769: missing FILE keyword

1 Answers  


ORA-09945: Unable to initialize the audit trail file

1 Answers  


ORA-28046: Password change for SYS disallowed

1 Answers  


ORA-38423: Attribute set created from an ADT may not be extended.

1 Answers  


NZE-29247: an unopen toolkit object was used before it was opened

1 Answers  


PLS-00731: ALTER TYPE is supported only on schema-level types

1 Answers  


PCC-02410: Expecting an expression of some Collection type.

1 Answers  


Categories