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 |
ORA-23382: materialized view repgroup "string"."string" is not registered at site string
ORA-16412: ONDEMAND archival requires active SQL apply operation
ORA-26510: materialized view name: 'string' is greater than max. allowed length of string bytes
ORA-12090: cannot online redefine table "string"."string"
CLSR-01002: Unable to process instance startup
PCB-00219: Invalid size specified in EXEC SQL VAR statement
UDI-00014: invalid value for parameter, 'string'
SQL*Loader-00531: OCI return status: still executing
LSX-00256: empty character class expression
ORA-06306: IPA: Message write length error
ORA-07392: sftcls: fclose error, unable to close text file.
ORA-03290: Invalid truncate command - missing CLUSTER or TABLE keyword