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 |
TNS-01033: Listener Parameter File string
DRG-10836: field section and attribute section can not be nested
ORA-28047: database is not a member of any enterprise domain in OID
ORA-36871: (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.
DRG-11708: too many thesauri
ORA-38611: FI input cursor's item type is not supported
ORA-30156: Out of disk space
ORA-33454: (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.
TNS-00519: Operating system resource quota exceeded
NZE-29234: a key object was not extracted from encoding
ORA-19691: %s is from different database: id=string, name=string
ORA-06145: NETTCP: unable to start ORASRV: images not installed