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