Oracle Error on exchange partition ORA-14099. How to check rows

I get error 'ORA-14099: all rows in table do not qualify for specified partition'

1. I create new empty partition p1 on Hash Partitioned Table t1
2. Create swap table CREATE TABLE t2 AS SELECT * FROM t1 WHERE 1 = 0
3. Do exchange empty partition and empty swap table alter table t1 exchange partition p1 with table t2 with validation
4. Load data to swap table
5. Do exchange empty partition and swap table with data with validation alter table t1 exchange partition p1 with table t2 with validation
6. Get error

If I use it without validation, It will work How to check which rows are invalid?

Related questions 1 How to see errors in Oracle? 0 Oracle SQL Error: How to Debug this issue 1 SQL Oracle error: ORA-00904 Related questions 1 How to see errors in Oracle? 0 Oracle SQL Error: How to Debug this issue 1 SQL Oracle error: ORA-00904 3 Oracle - Error on EXCHANGE PARTITION with List-Range partitioning 0 ORA-0097 error oracle sql 1 Oracle Database Error | ORA-12528 0 How can I fix 'ORA-00904' error in Oracle? 0 Elementary Oracle SQL Error message ORA-00900 1 Exchange Partition giving -Table or index is not partitioned. Invalid syntax 1 Alter Table Exchange Partition giving error Load 7 more related questions Show fewer related questions

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.