Skip to Content
0
Former Member
Apr 22, 2010 at 01:11 AM

Reading from R/3 source table with 59 million rows

32 Views

Hi,

Need an optimization advice regarding on extracting from a SAP R/3 table to Oracle target DBase. We have a source table named BSIS, BSEG and BKPF from SAP System, I used SAP R/3 DF to extract and join these tables and create a transport file. The problem is that it is taking too long to extract about 12 hours.

Anyone knows how to read/extract tables as huge as this one? Also, how am I going to read this using delta moving forward?

Thanks!

Randy