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-16521: unable to create generic template id
TNS-00514: Contexts have different wait/test functions
ORA-06518: PL/SQL: Probe version string incompatible with version string
ORA-22977: missing or invalid attribute
ORA-13900: missing or invalid parameter string
NNL-00240: Starting "string"...
ORA-30109: could not open parameter file 'string'
ORA-14060: data type or length of a table partitioning column may not be changed
NNF-03003: Format error parsing server response
ORA-16173: incompatible archival network connections active
QSM-01068: no dimensions present
ORA-19333: Invalid flags for the CREATE_DBURI operator