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

NNL-00572: set|show save_config_interval [<seconds>] [<server_list>] : set time of next config save

1 Answers  


ORA-07408: slbtpd: overflow while converting to packed decimal.

1 Answers  


PLS-01467: The value list of the IN predicate, if not a subquery, must contain only value_specifications

1 Answers  


ORA-25012: PARENT and NEW values cannot be identical

1 Answers  


ORA-37076: (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT and NTEXT.

1 Answers  


ORA-03204: the segment type specification should indicate partitioning

1 Answers  


ORA-00406: COMPATIBLE parameter needs to be string or greater

1 Answers  


ORA-14305: List value 'string' specified twice in partition 'string'

1 Answers  


ORA-26502: error resignal

1 Answers  


PROT-00011: Failed to open the specified destination cluster registry

1 Answers  


ORA-16741: The destination parameter of standby "string" has the wrong syntax.

1 Answers  


PLS-00617: at least one result in the CASE expression must not be NULL

1 Answers  


Categories