SQL*Loader-00820: cannot create where clause with range for
table string
- 1 Answers
- 2706 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-23472: materialized view "string"."string" must be atomically refreshed
UDI-00011: parameter string is incompatible with parameter string
ORA-00151: invalid transaction ID
ORA-01347: Supplemental log data no longer found
EXP-00040: Dump file and log file must be different
PLS-00605: set operators are not yet supported as an argument to a MULTISET operator
CLSR-00507: The length of the facility name string exceeds the limit (number)
DRG-50923: could not rewrite PL/SQL for execution
CLSR-00505: Empty event type is specified
NZE-29176: CRL signature verification failed
ORA-07207: sigpidu: process ID string overflows internal buffer.
PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statements
Oracle Errors 
