Database Error Messages

OCI-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 had a materialized view log. Each master table had 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.