Tag Archives: ORA-12000

ORA-12000: a materialized view log already exists on table ‘string’

oracle

ORA-12000: a materialized view log already exists on table ‘string’
Cause: An attempt was made to create a materialized view log on a table that already has a materialized view log. Each master table can have only one materialized view log.
Action: All materialized views on a table can use the same materialized view log for that table. To make changes to the existing log, use the ALTER MATERIALIZED VIEW LOG command or drop the materialized view log and create it again.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/