Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


SQL*Loader-00409: Number to skip must be table-level, not
load-level on continued loads



SQL*Loader-00409: Number to skip must be table-level, not load-level on continued loads..

Answer / guest

Cause: The SKIP parameter was specified on the command line
or in the OPTIONS statement, but the load was specified as
continued with CONTINUE_LOAD. When a multiple-table direct
load is interrupted, it is possible that a different number
of records were loaded into each table. As a result, the
number of records to skip must be specified for each table
when continuing the load. In this case, the load is
specified as continued with the CONTINUE_LOAD statement, and
the number of records to skip is given in each INTO TABLE
statement. See also messages 410 and 411 for more information.

Action: Check the log file to determine the appropriate
number of records to skip for each table and specify this
number in the INTO TABLE statement for each table in a
continued load or with the command-line SKIP parameter in a
standard load.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16413: Unsupported database type for ONDEMAND archivelog destinations

1 Answers  


ORA-27369: job of type EXECUTABLE failed with exit code: string

1 Answers  


ORA-09292: sksabln: unable to build archive file name

1 Answers  


ORA-27469: %s is not a valid string attribute

1 Answers  


ORA-22343: Compilation error for type invalidated by ALTER TYPE

1 Answers  






ORA-15133: instance recovery required for diskgroup string

1 Answers  


NNL-01032: Minimum TTL: string

1 Answers  


TNS-00311: Connection Manager: Failed to start tracing after rereading parameter data

1 Answers  


ORA-25526: bad format of _DB_MTTR_SIM_TARGET: string

1 Answers  


QSM-00802: An error occurred while implementing action string (string) string.

1 Answers  


ORA-10651: incorrect file number block number specified

1 Answers  


ORA-31697: aborting operation at process order number string

1 Answers  






Categories