Sunday, December 6, 2020

ora-12026 invalid filter column detected in materialized VIEW

 ora-12026 invalid filter column detected



Error code: ORA-12026

Description: invalid filter column detected

Cause: One or more of the specified filter columns did not exist or was a primary key column or a primary key based object identifier.

Action: Ensure that all specified filter columns exist in the master table and ensure that primary key columns or primary key based object identifiers are not included 

        in the list of filter columns.




Solution: Remove the columns other than the PK columns from sequence list

          and DO complete refresh of the MVIEW

  


No comments:

Post a Comment