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-28759: failure to open file
ORA-01658: unable to create INITIAL extent for segment in tablespace string
ORA-08230: smscre: failed to allocate SGA
SQL*Loader-00954: Error shipping index to read buffer across 2-task
ORA-32690: Hash Table Infrastructure ran out of memory
ORA-39307: the operation is illegal without an initial clone
ORA-31630: a job name is required to attach a job for user string
TNS-01188: Listener cannot operate with incompatible transport protocols
ORA-12830: Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE
DRG-13200: failed to load dictionary file string
RMAN-06424: error while looking up proxy copy
DRG-11521: encounter error when updating a LONG or LONG RAW column