When calculating a bind array size for a control file that has multiple
TABLE clauses, calculate as if the
TABLE clauses were not present. Imagine all of the fields listed in the control file as one, long data structure—that is, the format of a single row in the bind array.
If the same field in the data record is mentioned in multiple
TABLE clauses, then additional space in the bind array is required each time it is mentioned. It is especially important to minimize the buffer allocations for such fields.
Generated data is produced by the SQL*Loader functions
SEQUENCE. Such generated data does not require any space in the bind array.