Thanks Paul

We have been told there will be loads of UNDO space.

We do not have any indexes.

Entire 360 million belongs to one processing day. This will go to 1 single partition on the target table. That is why I thought swap partition is the best option.

Is there anything we can do like adding new HINTS in 11g, Server configuration, etc.

Thanks and Regards