Oracle Bulk Load
Posted: Thu Nov 04, 2010 1:04 pm
Hi folks, I am trying to use the Bulk Load option in the Oracle Connector stage.
I have found the following options are required to get a successful load:
1) Use before SQL statement to remove pk and and drop all indexes (including pk index).
2) Use after SQL statement to create pk and all indexes.
3) Set Index maintenance option to "Skip All"
4) Disable logging.
5) Perform operations before/after bulk load? No.
I am wondering if there is anything wrong with this. It seems to be working fine, it reduces my load time from 32 minutes to 14 minutes, although I haven't checked the db to see if it is actually using Direct Load.
Thanks,
Doug
I have found the following options are required to get a successful load:
1) Use before SQL statement to remove pk and and drop all indexes (including pk index).
2) Use after SQL statement to create pk and all indexes.
3) Set Index maintenance option to "Skip All"
4) Disable logging.
5) Perform operations before/after bulk load? No.
I am wondering if there is anything wrong with this. It seems to be working fine, it reduces my load time from 32 minutes to 14 minutes, although I haven't checked the db to see if it is actually using Direct Load.
Thanks,
Doug