SQL*Loader-00657
table string loaded using number passes, partition memory limit was numberkb, any data saves possibly ignored
Cause
Due to memory use, multiple passes were used to load some partitions.
Action
To decrease the number of passes, consider increasing the partition memory limit using the PARTITION_MEMORY command line option, or by increasing PGA_AGGREGATE_TARGET. Note that increasing the limit too much can cause the load to run out of memory.
SQL*Loader-00657
table string loaded using number passes, partition memory limit was numberkb
Cause
Due to memory use, multiple passes were used to load some partitions.
Action
To decrease the number of passes, consider increasing the partition memory limit using the PARTITION_MEMORY command line option, or by increasing PGA_AGGREGATE_TARGET. Note that increasing the limit too much can cause the load to run out of memory.
SQL*Loader-00657
table string loaded using number passes, partition memory limit was numberkb
Cause
Due to memory use, multiple passes were used to load some partitions.
Action
To decrease the number of passes, consider increasing the partition memory limit using the PARTITION_MEMORY command line option, or by increasing PGA_AGGREGATE_TARGET. Note that increasing the limit too much can cause the load to run out of memory.