Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.