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-00307: Warning: conflicting lengths number and
number specified for column string table string



SQL*Loader-00307: Warning: conflicting lengths number and number specified for column string table ..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-39013: All of the workers exited before the job completed.

1 Answers  


NNL-00500: Shows information on domains served by this server

1 Answers  


UDI-00012: table mode imports only allow objects from one schema

1 Answers  


QSM-02101: mv references a synonym in the FROM list

1 Answers  


TNS-02502: Authentication: unable to find initialization function

1 Answers  


RMAN-08544: channel string: specifying archivelog(s) for proxy restore

1 Answers  


ORA-34350: (MXDSS06) string is an open analytic workspace.

1 Answers  


ORA-15022: parameter length 'string' is longer than string

1 Answers  


ORA-01300: writable database required for specified LogMiner options

1 Answers  


TNS-01408: Instance "string", status string, has string handler(s) for this service...

1 Answers  


ORA-22814: attribute or element value is larger than specified in type

1 Answers  


ORA-07248: sfwfb: write error, unable to write database block.

1 Answers  


Categories