2 days for half a million is pitiful, how did they do it.

Export import would be faster.

You could drop the second table and do a ctas or insert append over a db link