Oracle Error SQL*Loader-00601: For INSERT option, table must be empty. Error on table string

Oracle 60 Views 0 Min Read

Oracle Error Message

SQL*Loader-00601: For INSERT option, table must be empty. Error on table string

Reason for the Error

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

Solution

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.

Tags: