文档解释
ORA-12027: duplicate filter column
Cause: One or more of the specified filter columns were already being recorded in the materialized view log.
Action: Describe the materialized view log table and reissue the SQL command with the filter columns that are already being recorded in the materialized view log.
ORA-12027:发生在将表或view中的列添加到基于表或view的过滤器中时,提示列重复。
官方解释
当在过滤器中添加表或视图中的列时,可能会发生重复列情况。此错误指示无法添加相同列。
常见案例
用户试图将同一列添加到同一过滤器,就会引发此错误。
正常处理方法及步骤
1.检查过滤器是否引用了相同的字段/列;
2.检查表中是否有列名相同的列;
3.检查视图是否引用了相同的字段/列。