Database Error Messages

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.