Many times the most efficient way to do something is to avoid having to do it at all. In your case, trying to avoid dumping the entire table and loading it again.

Is it possible to only copy new records and/or delete old ones?

Can you use a view that points to the Oracle data?

What else can you tell us about what you are trying to do?