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 |
IMG-00855: internal image index free failed
ORA-04042: procedure, function, package, or package body does not exist
ORA-07327: smpdal: attempt to destroy pga when it was not mapped.
ORA-23491: no valid extension request at "string"
ORA-25530: FAST_START_MTTR_TARGET is not specified
RMAN-12017: could not locate pieces of backupset key string
ORA-07705: sksaprs: device name buffer too small
ORA-13228: spatial index create failed due to invalid type
DRG-50954: Theme index is required for CTXCAT about queries
RMAN-08583: channel string: archivelog copy complete, elapsed time: string
RMAN-00570: **end-of-file**
QSM-02138: agg(expr) requires correspondng agg(expr*expr) function