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-16765: Physical apply service unexpectedly online
VID-00713: internal error while parsing video data
ORA-15150: instance lock mode 'string' conflicts with other ASM instance(s)
ORA-00322: log string of thread string is not current copy
ORA-01351: tablespace given for Logminer dictionary does not exist
QSM-00799: the user-defined workload table string cannot be found
ORA-37074: (XSMCSESS02) Variable workspace object has no default aggmap.
ORA-40272: apply rules prohibited for this model mode
ORA-19034: Type not supported during schema generation
PLS-00989: Cursor Variable in record, object, or collection is not supported by this release
TNS-12643: Client received internal error from server
ORA-36673: (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the <LEAF: VALUE> format.