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-00953: Cache lookup exact matches: number

1 Answers  


ORA-07416: slpath: pathname construction failed; lack of output buffer space.

1 Answers  


ORA-13441: GeoRaster metadata SRS error

1 Answers  


ORA-32129: cannot get information about this column

1 Answers  


ORA-32026: %s.string has fewer columns compared to string table.

1 Answers  






PCC-00031: Invalid value given for option "string"

1 Answers  


ORA-37104: (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.

1 Answers  


ORA-25282: message id. not provided for non-repudiation

1 Answers  


ORA-07650: sigunc: $GETJPIW failure

1 Answers  


DRG-52210: error while registering value for attribute: string

1 Answers  


ORA-00824: cannot set sga_target due to existing internal settings

1 Answers  


ORA-01413: illegal value in packed decimal number buffer

1 Answers  


Categories