How to display discrepancies from two large tables?

Question

Oracle

Hello!
There are two tables in which approximately on 22 million records. You need to check them and remove the discrepancies. Advise the fastest way to withdraw the difference.

Answer 1

Is it https://docs.oracle.com/cd/B28359_01/server.111/b2... ?
---------------------
INTERSECT Example The following statement combines the results with the INTERSECT operator, which returns only those unique rows returned by both queries:
SELECT product_id FROM inventories
INTERSECT
SELECT product_id FROM order_items
ORDER BY product_id;
MINUS Example The following statement combines results with the MINUS operator, which returns only unique rows returned by the first query but not by the second:
SELECT product_id FROM inventories
MINUS
SELECT product_id FROM order_items
ORDER BY product_id;
----------------------

Answer 2

You can use dbForge Schema and Data Compare for Oracle for this task