Hi Friends.
I want to improve the speed of my data load activity using sql loader.
Details:
My current configuration "rows=4000000 bindsize=20480000 direct=y" .
Total rows to be inserted = approx. 50M
Scenario:
My table is range partitioned using "interval (numtodsinterval(1,'day')) "and each partition is loaded daily with data worth over 2GB of data.
This import takes about 3-4 hours. I don't drop the only index ( local partitioned) on this table ( oracle creates the index after the direct load itself).
Can you please suggest me a faster approach with below details:
1. I can't drop the index ( It is of size 90GB) because i have to do this activity daily.
2. This data load activity happens daily and the whole is needed by other team members for analysis purposes.
My objective : to reduce the data load time as this everyone has to wait for this data load to complete for analysis.