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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

ORA-26030: index string.string had string partitions made unusable due to:

1552


IMG-02003: 2FF03 - incorrect color histogram feature specification

1195


ORA-16627: No standby databases support the overall protection mode.

3547


ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2309


In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2320






ORA-26079: file "string" is not part of table string.string

1513


ORA-26094: stream format error: input column overflow

2243


ORA-26082: load of overlapping segments on table string.string is not allowed

1366


When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2308


if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2227


[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2280


ORA-26027: unique index string.string partition string initially in unusable state

6149


ORA-16626: failed to enable specified object

1767


IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1232


ORA-26029: index string.string partition string initially in unusable state

1701