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 |
NZE-28808: Cannot retrieve method information from the configuration file.
ORA-30011: Error simulated: psite=string, ptype=string
DRG-11512: bad syntax for thesaurus load file at line string
ORA-30434: refresh method must be one of FC?AN, not 'string'
ORA-09823: device name is too long
ORA-06040: NETDNT: invalid login (connect) string
PLS-00251: RETURN, for actual function return, must be last in the parameters clause
RMAN-08159: executing global script: string
KUP-04005: file operation successful
ORA-01680: unable to extend LOB segment by string in tablespace string
ORA-00280: change string for thread string is in sequence #string
ORA-01557: rollback segment extents must be at least string blocks