SQL*Loader-00307: Warning: conflicting lengths number and
number specified for column string table string
Answer / guest
Cause: The SQL*Loader control file specifies two different
lengths for the named column. There are three ways to
specify the length of a field: --with the POSITION keyword:
POSITION(1:3) -- with the length specifier: CHAR(6) -- with
the implied length of a datatype; for example, INTEGER -- A
conflict could occur between any two of these specifications
(or among all three, but only two are shown). A common cause
of this error is the specification of some numeric datatype,
such as INTEGER, when the numeric external form is intended
(INTEGER EXTERNAL). The external form consists of character
data, so it is considerably longer than the numeric form,
which consists of binary data.
Action: No action is necessarily required, because
SQL*Loader uses only one of the lengths. Check the log file
under the heading "Len" in the table-description section to
see which length was used. Adjusting the SQL*Loader control
file to produce uniform length specifications will remove
the warning.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
ORA-39013: All of the workers exited before the job completed.
NNL-00500: Shows information on domains served by this server
UDI-00012: table mode imports only allow objects from one schema
QSM-02101: mv references a synonym in the FROM list
TNS-02502: Authentication: unable to find initialization function
RMAN-08544: channel string: specifying archivelog(s) for proxy restore
ORA-34350: (MXDSS06) string is an open analytic workspace.
ORA-15022: parameter length 'string' is longer than string
ORA-01300: writable database required for specified LogMiner options
TNS-01408: Instance "string", status string, has string handler(s) for this service...
ORA-22814: attribute or element value is larger than specified in type
ORA-07248: sfwfb: write error, unable to write database block.