I am going to follow you on this as I want to batch load data into an Oracle table to create multiple requisitions. You see in the development of a Supermarket Food Store there are various kind of equipment, saws, ovens. Scales, Refrigerated cases, coolers, freezers, etc.; ordered from various vendors. So I want to take an Excel Equipment list, load it into Oracle to create multiple Requisitions.
Is it doable.
Thanks
jim
| | | ---------------Original Message---------------
From: ABAPxxxGoddess
Sent: Monday, October 11, 2010 3:59 AM
Subject: Bulk insert SQL command to transfer data from SAP to Oracle - CL_SQL_CONNECTION
Horacio,
I found your hashed table pretty interesting and useful when doing performance tuning. But this one is more useful when doing queries from tables with huge data, rather than looping at it then do insert to a remote database (please correct me if I'm wrong). So far, the main bottleneck of my program's performance is that insertion to the Oracle part where it's taking up so much time. I think, even if I used a hashed table, it would still make no difference in my case for I'm not doing anymore processing of data where primary keys should be considered, just a simple insert to Oracle row by row. And the main reason is the connection, perhaps. But thanks a lot for this very useful info about hashed table. You've given a very good idea when doing a performance tuning. I normally use standard table only. But now, I know when to use hashed table.
Mark,
at this very moment, I'm still waiting for our Basis team to do that DBLink. Anyway, it's now returning an Oracle message saying something like dblink not found. So I guess, that's it. Thanks a lot for this one. Well, I guess bottomline of this would be, if ur not experiencing connection issue you go with the hashed table - a very simple yet very effective one. Otherwise, use the DBLink option. But I'd also love to hear if u can get exec sql work with itabs.
For that username? hehe, nothing but just making it more positive and charming ;) |
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Related Content Most Popular White Papers
In the Spotlight  _.____.__ |
Mark as helpful
