BUG

Copying rows between two Oracle tables with blob columns fails

Last Published: April 25, 2020

Description

Copying rows between two Oracle tables with blob columns fails at some point with an ORA-03127 error.

Cause

This is due to an Oracle 8i bug.

Workaround

The problem is resolved in the latest patches of ArcSDE 9.0 and 9.1 for Oracle 9i Release 2 and up. There is still a problem with earlier versions of Oracle 8i that may be resolved with the latest patches to Oracle 8i. The best solution is to upgrade to the latest version of Oracle 9i Release 2 or higher.

Article ID: 000008458

Software:
  • Legacy Products

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