Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-28231: no data passed to obfuscation toolkit

1 Answers  


IMG-00555: invalid value for gamma correction

1 Answers  


PLS-01501: Options in CREATE TABLE statement is non-ANSI.

1 Answers  


ORA-30370: set operators are not supported in this context

1 Answers  


ORA-08000: maximum number of session sequence lists exceeded

1 Answers  






if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

0 Answers   Wipro,


ORA-17622: failed to deregister the memory with Oracle Disk Manager library

1 Answers  


ORA-28237: seed length too short

1 Answers  


ORA-12446: Insufficient authorization for administration of policy string

1 Answers  


ORA-30432: summary 'string.string' is in INVALID state

1 Answers  


PLS-00709: pragma string must be declared in package specification and body

1 Answers  


ORA-10921: Cannot drop tablespace belonging to default temporary tablespace group

1 Answers  






Categories