FAQ: ArcCatalog Copy/Paste Fails with Network I/O Error When Oracle8i Target Database's GD

Answer

The GDB_OBJECTCLASSES table's EXTPROPS column will be defined as BLOB if the DBTUNE DATA_DICTIONARY keyword ATTRIBUTE_BINARY parameter is set to BLOB when the ArcSDE sdesetupora8i program creates the geodatabase metadata tables.

If the ATTRIBUTE_BINARY parameter is set to LONGRAW, the EXTPROPS column is defined as LONGRAW.

A target database containing a GDB_OBJECTCLASSES table with the EXTPROPS column defined as BLOB cannot be copied into because ArcSDE SE_stream_update_table function's internal BLOB column bind variable has not been properly initialized.

To work around this problem define all target database metadata columns containing binary data as LONG RAW rather than BLOB. To do this set the DBTUNE DATA_DICTIONARY keyword ATTRIBUTE_BINARY parameter to LONGRAW rather than BLOB before you create the database with the sdesetupora8i command.

Article ID:000003589

Software:

ArcMap 8 x
Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

ArcCatalog Copy/Paste fails with network I/O error when Oracle8i target database's GDB_Objectclasses table EXTPROPS column is defined as BLOB

Answer

Discover more on this topic