invalid predicate in partition <str> Explanation: The WHERE clause specifying which rows to chose from a partition in a partitioned view is specified incorrectly. The condition must be of the form: WHERE column-name comp literal or column-name IS NULL or column-name BETWEEN literal and literal or OTHERWISE, where comp is either <, <=, =, >=, or >. User Action: Check that the column-name specified is that of the partitioning column and that the comparison operator is in the list above.