huge table copy avoid duplicates
I am not an Oracle expert, but I can answer from DB2 perspective, you may look for similar features/commands in Oracle. In DB2, you can achieve this by:


Using Import command with INSERT_UPDATE option.
You also have a choice to use MERGE statement to merge data between two tables.


Hope it helps you.