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

ORA-09858: sfngat: the input file name is not in the OMF format

1 Answers  

---

NNL-00016: cannot start server, error getting program directory's name

1 Answers  

---

ORA-07613: $GETJPIW failed in retrieving the user's process label

1 Answers  

---

ORA-01539: tablespace 'string' is not online

1 Answers  

---

ORA-31672: Worker process string died unexpectedly.

1 Answers  

---

ORA-23361: materialized view "string" does not exist at master site

1 Answers  

---

NID-00416: Change of database name failed.

1 Answers  

---

ORA-07390: sftopn: translate error, unable to translate file name.

1 Answers  

---

NZE-28777: binding creation failure

1 Answers  

---

ORA-00207: controlfiles are not for the same database

1 Answers  

---

ORA-22897: no scope clause specified for user-defined REF column "string"

1 Answers  

---

SQL*Loader-00926: OCI error while string for table string

1 Answers  

---