I have partitioned a table with about 40 M records to have 2 partitions. I am now loading (about 2 M records) of data using sqlldr directly into the partitioned tables.
Earliar without the partitioning, the load used to take less than an hour, but now the load never completes.
I am just using 'Insert into partition_table' but am not specifing the partition. ---Does does matter.
So are there any other things that I have to modify for loading the data into partitioned tables with sqlldr.,---- to make it faster.
Click Here to Expand Forum to Full Width