If your're loading data from SQLServer into Oracle, you should see if the Oracle table is using Indexes.

You should drop then first and re-create then when the loading finish.

perhaps you...