Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

NZE-28759: failure to open file

1 Answers  


ORA-01658: unable to create INITIAL extent for segment in tablespace string

1 Answers  


ORA-08230: smscre: failed to allocate SGA

1 Answers  


SQL*Loader-00954: Error shipping index to read buffer across 2-task

1 Answers  


ORA-32690: Hash Table Infrastructure ran out of memory

1 Answers  


ORA-39307: the operation is illegal without an initial clone

1 Answers  


ORA-31630: a job name is required to attach a job for user string

1 Answers  


TNS-01188: Listener cannot operate with incompatible transport protocols

1 Answers  


ORA-12830: Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE

1 Answers  


DRG-13200: failed to load dictionary file string

1 Answers  


RMAN-06424: error while looking up proxy copy

1 Answers  


DRG-11521: encounter error when updating a LONG or LONG RAW column

1 Answers  


Categories