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

QSM-02009: non-inner join

1 Answers  


ORA-07804: slpdtb: number too large for supplied buffer

1 Answers  


NZE-29044: Renegotiation has already been requested.

1 Answers  


ORA-21501: program could not allocate memory

1 Answers  


QSM-02055: mv references a packed object table or view

1 Answers  






ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine

2 Answers   HCL,


ORA-36270: (XSCGMDLAGG03) The right-hand side of the AGGREGATION function includes duplicate values.

1 Answers  


RMAN-08036: channel string: could not create controlfile record for string string

1 Answers  


ORA-22321: method does not return any result

1 Answers  


TNS-01063: The db subagent is not started.

1 Answers  


DRG-11004: duplicate or conflicting value for string

1 Answers  


ORA-32641: invalid expression in MODEL rule ORDER BY clause

1 Answers  


Categories