SQL*Loader-00820: cannot create where clause with range for table string
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.
SQL*Loader-00821
Custom Search


More Oracle errors
ORA-15109conflicting protection attributes specified
RMAN-06062can not backup SPFILE because the instance was not started with SPFILE
ORA-13791cannot resume a task created to process a single statement
ORA-26085direct path operation must start its own transaction
ORA-14018partition bound list contains too few elements
DRG-13200failed to load dictionary file string
ORA-02276default value type incompatible with column type
ORA-19609string is from different backup set: stamp string count string
ORA-01309invalid session
ORA-26713remote object does not exist or is inaccessible
ORA-10664Table has bitmap join indexes
PCC-02342using WHERE CURRENT OF on cursor defined without FOR UPDATE clause
PCC-00105Keyword WORK required here by ANSI
ORA-06260NETNTT: cannot write to remote process
ORA-22902CURSOR expression not allowed
ORA-29953cannot issue DDL on a domain index partition marked as FAILED
TNS-00293Trace File Name : string
ORA-02764Invalid package mode
ORA-22869depth of type dependency hierarchy exceeds maximum limit
ORA-27412repeat interval or calendar contains invalid identifier: string




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
SQL*Loader-00820cannot create where clause with range for table string