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-00367: checksum error in log file header
DRG-10204: server update failed
ORA-14055: keyword REBUILD in ALTER INDEX REBUILD must immediately follow <index name>
DRG-12308: use ctx_ddl.create_index_set to create index sets
ORA-00343: too many errors, log member closed
PCB-00231: Host and indicator variables may not have the same name.
ORA-23447: missing user parameter value
EXP-00105: parameter string is not supported for this user
ORA-25402: transaction must roll back
ORA-30944: Error during rollback for XML schema 'string' table string column 'string'
ORA-08459: invalid format parameter length
ORA-13798: Parameter string cannot be NULL.