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

ORA-00367: checksum error in log file header

1 Answers  


DRG-10204: server update failed

1 Answers  


ORA-14055: keyword REBUILD in ALTER INDEX REBUILD must immediately follow <index name>

1 Answers  


DRG-12308: use ctx_ddl.create_index_set to create index sets

1 Answers  


ORA-00343: too many errors, log member closed

1 Answers  


PCB-00231: Host and indicator variables may not have the same name.

1 Answers  


ORA-23447: missing user parameter value

1 Answers  


EXP-00105: parameter string is not supported for this user

1 Answers  


ORA-25402: transaction must roll back

1 Answers  


ORA-30944: Error during rollback for XML schema 'string' table string column 'string'

1 Answers  


ORA-08459: invalid format parameter length

1 Answers  


ORA-13798: Parameter string cannot be NULL.

1 Answers  


Categories