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

O2U-00210: Unable to allocate memory

1 Answers  


RMAN-06422: no channels found for SEND command

1 Answers  


PROC-00017: Unimplemented feature

1 Answers  


ORA-26507: null master connection

1 Answers  


ORA-14264: table is not partitioned by Composite Range method

1 Answers  






ORA-14174: only a <parallel clause> may follow COALESCE PARTITION|SUBPARTITION

1 Answers  


ORA-07569: slspool: $CLOSE failure

1 Answers  


NNL-00901: CONTENT ERROR responses sent: number

1 Answers  


DRG-10837: section string does not exist

1 Answers  


ORA-30926: unable to get a stable set of rows in the source tables

2 Answers  


ORA-01779: cannot modify a column which maps to a non key-preserved table

1 Answers  


ORA-25952: join index must only contain inner equi-joins

1 Answers  


Categories