English

Error: Oracle ORA-1438

Error Message

SDE Error(-51) Underlying DBMS error
Extended error code(1438): ORA-01438: value larger than specified precision

Cause

Oracle 1438 error occurs when a column in the source data (shapefile or coverage) has a definition that is not large enough for the data it contains.

Many times this is the AREA or PERIMETER column of a data source.

Solution or Workaround

Try the "-a file=<col_selection_filename>" option to increase
the output column's size instead of taking the default.

The format of the file specified as <col_selection_filename> should be in the following format.

AREA AREA DOUBLE 20,3
PERIMETER PERIMETER DOUBLE 20,3
STATESP075 STATESP075 DOUBLE 16
STATE
STATE_FIPS

This option is available with the shp2sde and cov2sde commands.