Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-12036: updatable materialized view log is not empty,
refresh materialized view
- 1 Answers
- 3128 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 |
ORA-12024: materialized view log on "string"."string" does not have primary key columns
ORA-08111: a partitioned index may not be coalesced as a whole
ORA-39079: unable to enqueue message string
PCC-02040: CMD-LINE: Option selected, but no value provided
ORA-30945: Could not create mapping table 'string'
PCC-02133: CMD-LINE: Error in string processing function
ORA-24364: internal error while padding blanks
ORA-29298: Character set mismatch
ORA-13505: SYSAUX tablespace can not be made read only
NID-00452: Succesfully changed database ID.
NNL-00872: Updates refused, data is topology data: number
PCC-00005: Unsupported datatype in line number of file string
Oracle Errors 
