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

RMAN-06025: no backup of log thread number seq number lowscn string found to restore

1 Answers  


ORA-07548: sftopn: Maximum number of files already open

1 Answers  


NPL-00304: uninitialized ASN.1 tag attribute

1 Answers  


ORA-04078: OLD and NEW values cannot be identical

1 Answers  


ORA-22978: only simple attribute name is allowed in the WITH OBJECT OID clause

1 Answers  






ORA-38760: This database instance failed to turn on flashback database

1 Answers  


ORA-19720: Error occurred when converting an OCI number into an SCN

1 Answers  


ORA-15104: conflicting CONTENTS options

1 Answers  


ORA-02722: osnpui: cannot send break message to orapop

1 Answers  


ORA-02185: a token other than WORK follows COMMIT

1 Answers   IBM,


ORA-19331: Last argument to CREATE_DBURI operator must be a column

1 Answers  


TNS-12519: TNS:no appropriate service handler found

1 Answers  


Categories