Database Error Messages

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

SQL*Loader-00601

For INSERT option, table must be empty. Error on table string

Cause

A non-empty table is being loaded with the INSERT option.


Action

Use the REPLACE keyword to empty the old table and store the new data in its place. Use the APPEND keyword to leave the table's contents intact and add the new data to it.