|Load Utility in DB2 - Alternative in Oracle? [message #376062]
||Mon, 15 December 2008 21:43
Registered: August 2007
I have used the load utility in db2 to load large amounts of data faster.
In addition to the above, it has the added flexibility that any records that get rejected in the process of loading are written into another table.
create table STOP_ACTION_ORDER_exception as select * from STOP_ACTION_ORDER where 1=2;
declare stop_action_order cursor for
FROM ORDERS O
INNER JOIN STOP_ACTION S ON S.SHIPMENT_ID = O.SHIPMENT_ID;
load from stop_action_order of cursor
INSERT INTO STOP_ACTION_ORDER
for exception STOP_ACTION_ORDER_exception;
The above queries load data as per the insert statement into STOP_ACTION_ORDER.
The records that fail to get inserted are moved into
Is there some way the same can be done in Oracle?