ORA-12036: updatable materialized view log is not empty,
refresh materialized view
- 1 Answers
- 2738 Views
- I also Faced
- E-Mail Answers
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 |
EXP-00103: The FLASHBACK_TIME parameter was invalid
ORA-02231: missing or invalid option to ALTER DATABASE
ORA-24805: LOB type mismatch
ORA-27203: skgfpqb: sbtpcquerybackup returned error
ORA-36694: (XSRELTBL01) The value cannot be added to dimension workspace object.
ORA-24124: invalid ACTION parameter passed to DBMS_REPAIR.string procedure
ORA-01676: standby file name convert of 'string' exceeds maximum length of string
ORA-19656: cannot backup, copy, or delete online log string
ORA-07251: spcre: semget error, could not allocate any semaphores.
ORA-14078: you may not drop the highest partition of a GLOBAL index
ORA-13356: adjacent points in a geometry are redundant
NNL-00980: Forwarding failures: number
Oracle Errors 
