Are you talking about using a table to update/insert the
other table, or just load those data to tables directly?
I have tried SQLLoader in conventional mode and direct mode
It gave huge enhancement on loading. Maybe you can
try to work on how to load in direct mode, disable triggers,
constraints first, enable them after you load it. Or run
PL/SQL to enforce whatever you want to complish. That is
what I did. I save a lot of time on loading, some improvement
on PL/SQL scripts.
Also try load in parallel , spread those tables in different tablespaces
on different drives.
Hope it works better.
--
Shiang-Huey Wang
Leather Center, Inc.
sherry_at_leathercenter.com
wshiang_at_a.cs.okstate.edu
Received on Wed Dec 11 1996 - 00:00:00 CST
