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

TNS-01033: Listener Parameter File string

1 Answers  


DRG-10836: field section and attribute section can not be nested

1 Answers  


ORA-28047: database is not a member of any enterprise domain in OID

1 Answers  


ORA-36871: (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.

1 Answers  


DRG-11708: too many thesauri

1 Answers  


ORA-38611: FI input cursor's item type is not supported

1 Answers  


ORA-30156: Out of disk space

1 Answers  


ORA-33454: (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.

1 Answers  


TNS-00519: Operating system resource quota exceeded

2 Answers  


NZE-29234: a key object was not extracted from encoding

1 Answers  


ORA-19691: %s is from different database: id=string, name=string

1 Answers  


ORA-06145: NETTCP: unable to start ORASRV: images not installed

1 Answers  


Categories