ERROR

Oracle ORA-1438

Last Published: April 25, 2020

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.

Article ID:000002330

Software:
  • ArcMap 8 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options