How is the performance for a large data set?

Interesting... thanks, Frederico.

I'm not sure how the use of CDC will help you replicate to Oracle.

Post removed... I misread the code.  See Jacob's post below.

Do a BCP out to a file and have Oracle import it (I can't remember the name of the built in tool on the Oracle side).  The last...

I recommend that you onvert that spreadsheet to actual INSERTs to a table to help us help you.  Please see the first link in my signature line below for details.

Thank you Frederico.

Completely agreed with that view will be the issue as joining multiple tables and using some function which slows down the process.

But didn't not much fully understood...

That would explain it... I didn't download the plan.

We need the actual execution plan and the original code that you published on Brent's site, as well, please.

Do a BCP out to a file and have Oracle import it (I can't remember the name of the built in tool on the Oracle side).  The last time I...

p.s.  Since we're actually trying to help you tune the view, it would be helpful if you actually posted the code for the view, as well.

Jeff,

Thank you for your response and suggesting about other details, i am totally agreed with you.

i have link for the plan, please see the following link if you don't...

That was going to be my suggestion if the OP ever came back on this thread except I wouldn't limit the batches.  First, BCP automatically limits itself to 1,000 rows...

What did you end up doing for this?  Inquiring minds want to know. 😀

If you want help with such a performance issue, please see the 2nd link in my signature line below for how to present it in the best way possible to...