SQL*Loader-00820: cannot create where clause with range for
table string
Answer / guest
Cause: The EXTERNAL_TABLE parameter was specified for a
multi-table load, and a WHEN clause for one of the tables
contains a reference to a range of bytes in the record. SQL
Loader uses the WHEN clause from the control file to
generate the WHERE clause in the INSERT statement. If the
WHERE clause contains a reference to a range of bytes in the
table, then a valid WHERE clause can not be generated. Note
that SQL Loader will proceed as if GENERATE_ONLY was
specified for the EXTERNAL_TABLE parameter.
Action: Modify the control file to only use field references
in the WHEN clause. Note that this may require creating a
filler field. Another alternative is to create one control
file for each table to be loaded and load the table separately.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-37081: Requested advice produced no precomputes
SQL*Loader-00514: Error getting elapsed time
ORA-02158: invalid CREATE INDEX option
ORA-16000: database open for read-only access
ORA-07658: slsprom:$QIOW read failure
ORA-31427: publication string already subscribed
ORA-09777: osnpbr: cannot send break message
ORA-13039: failed to update spatial index for element string.string.string
KUP-04039: unexpected error while trying to find file string in string
ORA-09952: scgcmn: lk_open_convert unexpected return: open failed
ORA-09821: Numeric label is not valid
ORA-00207: controlfiles are not for the same database