SQL*Loader-00820: cannot create where clause with range for
table string



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

Post New Answer

More Oracle Errors Interview Questions

NNL-00872: Updates refused, data is topology data: number

1 Answers  


ORA-32036: unsupported case for inlining of query name in WITH clause

1 Answers  


NNO-00071: cannot construct cache checkpoint file name

1 Answers  


ORA-09262: spdde: error terminating detached (background) process

1 Answers  


CLSR-00523: Resource string is not enabled

1 Answers  






EXP-00020: failed to allocate memory of size number

2 Answers  


ORA-32005: error while parsing size specification [string]

1 Answers  


ORA-22897: no scope clause specified for user-defined REF column "string"

1 Answers  


TNS-01154: SID detected in old format that is no longer supported

1 Answers  


ORA-12636: Packet send failed

2 Answers  


ORA-22337: the type of accessed object has been evolved

1 Answers  


ORA-01346: Dependent LogMiner sessions relying on supplementally logged data exist

1 Answers  


Categories