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-12548: TNS:incomplete read or write
PCB-00638: This attribute is only valid for internal or external LOB types
RMAN-06422: no channels found for SEND command
ORA-13417: null or invalid layerNumber for get functions
RMAN-06537: CHANGE ... KEEP not supported for BACKUP
TNS-01201: Listener cannot find executable string for SID string
TNS-00536: Connection entered inappropriate state
ORA-26668: STREAMS process string exists
ORA-23536: the object "string"."string" is not cached at the middle tier as expected.
ORA-02332: cannot create index on attributes of this column
ORA-09214: sfdone: I/O error detected
ORA-12802: parallel query server lost contact with coordinator