ORA-01400: cannot insert into" table when loading into Oracle

Last Published: April 25, 2020

Error Message

While copying, pasting or loading a feature class or table from a non-Oracle geodatabase into Oracle, the following error is returned:

"Underlying RDBMS error [ORA-01400: cannot insert into ("TB","MYTABLE","MYFIELD")]"


This error can occur when there are zero-length ('') strings in a table field. These are valid in a file geodatabase, personal geodatabase and most supported RDBMS, such as SQL Server, Informix, DB2, and PostgreSQL, but are interpreted as NULLs in Oracle. When using copy/paste or any data-loading tool, records containing '' (zero-length) strings are rejected if the field is flagged to not allow NULLs.

Solution or Workaround

Replace all occurrences of zero-length strings in the text fields with ' ' (a quoted blank space).

Use the following WHERE clauses to select the zero-length strings and then update the field values to a quoted single space (' ').

File Geodatabase:
CHAR_LENGTH(myfield) = 0

Personal Geodatabase:
LEN(myfield) = 0

SQL Server:
DATALENGTH(myfield) = 0

LENGTH(myfield) = 0

CHAR_LENGTH(myfield) = 0

CHAR_LENGTH(myfield) = 0

    Article ID:000011559

    • ArcGIS Server

    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

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options