BUG
When using the 'sdeexport' command with the -O option when the layer is using st_geometry in Oracle, the following underlying DBMS error is encountered:
Code:
sdeexport -o create -l cntry,shape -O -f cntry_exp -u gdb -p gdb -s laurel -i esri_gdbArcSDE 9.3 for Oracle10g Build 440 Sun Jan 6 12:00:15 2008
SDEX File Export Administration Utility
-----------------------------------------------------
Exporting ArcSDE object to "cntry_exp" in SDEX export format ...
Exporting table "cntry".
Spatial column "SHAPE"
SDE Code (-51)= Underlying DBMS error
Extended DBMS error code: 904
ORA-00904: "S_"."GY": invalid identifier
SELECT CNTRY.SHAPE.area, NAME, ABBREVNAME, FIPS_CODE, WB_CNTRY, 1 SHAPE, OBJECTID, CNTRY.SHAPE.points,CNTRY.SHAPE.numpts,CNTRY.SHAPE.entity,CNTRY.SHAPE.minx,CNTRY.SHAPE.miny,CNTRY.SHAPE.maxx,CNTRY.SHAPE.maxy,CNTRY.rowid
FROM GDB.CNTRY CNTRY WHERE ST_EnvIntersects(CNTRY.SHAPE,:1,:2,:3,:4) = 1 AND s_.rn =1
order by s_.gx, s_.gy
Error in stream fetch.
SDE Code (-1): Operation Failed
Error in exporting SDE feature/attribute data.Error exporting SDE export file.
sdeexport error.
1 features converted.
0 features exported.
There is an invalid binding specification within the 'sdeexport' command; therefore the SQL statement cannot fetch the data in the order of the spatial index, which results in the underlying DBMS error.
Article ID:000010185
Get help from ArcGIS experts
Download the Esri Support App