SQL*Loader-00820: cannot create where clause with range for
table string
- 1 Answers
- 1763 Views
- I also Faced
- E-Mail Answers
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-28231: no data passed to obfuscation toolkit
IMG-00555: invalid value for gamma correction
PLS-01501: Options in CREATE TABLE statement is non-ANSI.
ORA-30370: set operators are not supported in this context
ORA-08000: maximum number of session sequence lists exceeded
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
ORA-17622: failed to deregister the memory with Oracle Disk Manager library
ORA-28237: seed length too short
ORA-12446: Insufficient authorization for administration of policy string
ORA-30432: summary 'string.string' is in INVALID state
PLS-00709: pragma string must be declared in package specification and body
ORA-10921: Cannot drop tablespace belonging to default temporary tablespace group
Oracle Errors 
