English

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

Question

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

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.