Currently I use an ORAOCI9 Stage to Update existing records and Insert new ones. I'd like to use a bulk loader to carry out this process as it currently takes a long time to load records. Is this possible?
Can anyone give me some suggestions?
Bulk Loader using oracle 10g
Moderators: chulett, rschirm, roy
Bulk Loader using oracle 10g
from SPA_BI
Re: Bulk Loader using oracle 10g
Hi,SPA_BI wrote:Currently I use an ORAOCI9 Stage to Update existing records and Insert new ones. I'd like to use a bulk loader to carry out this process as it currently takes a long time to load records. Is this possible?
Can anyone give me some suggestions?
Don't think sqlloader lets your perform UPDATES but for INSERTs it's what it's designed for . SO in your job split your UPDATES and INSERTS, for updates you'll still need to use ORAOCI9 but for the INSERTs try sqlloader.
You can also try a couple of other techniques. One is to bulk load your inserts directly into the target table and bulk load the updates into a work table. Then an Oracle MERGE can perform the updates.
Another approach is to ensure all you do are inserts. Any changed records can be deleted from the target first and then everything can be bulk loaded as an insert.
Always more than one way to approach something, it seems.
Another approach is to ensure all you do are inserts. Any changed records can be deleted from the target first and then everything can be bulk loaded as an insert.
Always more than one way to approach something, it seems.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers