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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00970: System query index number: number

1 Answers  


QSM-02077: mv log is newer than last full refresh

1 Answers  


UDI-00007: attempt to free unallocated memory

1 Answers  


ORA-23410: materialized view "string"."string" is already in a refresh group

1 Answers  


SQL-02135: Unable to initialize date format using supplied mask

1 Answers  






NNL-00990: DEFAULT-FORWARDERS-ONLY mode: string

1 Answers  


PCC-02111: CHAR_MAP option ignored. Only CHAR_MAP=VARCHAR2 allowed for DBMS=V6

1 Answers  


ORA-06514: PL/SQL: The remote call cannot be handled by the server

1 Answers  


ORA-06956: Failed to get local host name

1 Answers  


ORA-37081: Requested advice produced no precomputes

1 Answers  


ORA-30754: column or table string stores objects of only one type

1 Answers  


ORA-12040: master rollback segment option not support by master site string

1 Answers  


Categories