Is This Content Helpful?
We're glad to know this article was helpful.
Using ArcCatalog, ArcToolbox, or ArcSDE Administration commands to export an Oracle Spatial layer loaded through ArcGIS tools to a shapefile returns the error:
"<SDE connection\Owner.Table> contains the Blob field: SE_ANNO_CAD_DATA. The output shapefile will not contain this Blob field."
Following the above errors additional error may occur.
This error has been resolved in ArcGIS 8.3.
Oracle Spatial, the SDO_GEOMETRY data type, does not support annotation features, parametric curve features, or CAD data. When creating new feature classes stored as Oracle Spatial, ArcGIS implements these types of features through a BLOB column called SE_ANNO_CAD_DATA. When a feature class is created, ArcGIS assumes that the SE_ANNO_CAD_DATA column will be needed.
The ArcCatalog, ArcToolbox, and ArcSDE Administration command exporters do not exclude the SE_ANNO_CAD_DATA column from the export. BLOB data types are not supported in shapefiles, resulting in a failed export.
Use the following steps to hide the SE_ANNO_CAD_DATA column and export the Oracle Spatial layer to a shapefile using ArcMap.
The sde2shp command with the -a flag can be used.