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-16765: Physical apply service unexpectedly online

1 Answers  


VID-00713: internal error while parsing video data

1 Answers  


ORA-15150: instance lock mode 'string' conflicts with other ASM instance(s)

1 Answers  


ORA-00322: log string of thread string is not current copy

1 Answers   Sabro,


ORA-01351: tablespace given for Logminer dictionary does not exist

1 Answers  


QSM-00799: the user-defined workload table string cannot be found

1 Answers  


ORA-37074: (XSMCSESS02) Variable workspace object has no default aggmap.

1 Answers  


ORA-40272: apply rules prohibited for this model mode

1 Answers  


ORA-19034: Type not supported during schema generation

1 Answers  


PLS-00989: Cursor Variable in record, object, or collection is not supported by this release

1 Answers  


TNS-12643: Client received internal error from server

1 Answers  


ORA-36673: (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the <LEAF: VALUE> format.

1 Answers  


Categories