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

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

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.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...