The 'sdeexport' file from ArcSDE on Informix fails to 'sdeimport' in ArcSDE on Oracle with 'init' and 'append' options throwing an INCOMPATIBLE_SCALE_XY error.
上次发布: December 16, 2014ArcSDE/Enterprise Geodatabase
漏洞 ID 编号
NIM047727
已提交
August 24, 2009
上次修改时间
April 2, 2025
适用范围
ArcSDE/Enterprise Geodatabase
找到的版本
9.3.1
操作系统
Windows OS
操作系统版本
2003
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
The 10.2.x releases are the last releases that include the command tools, Please use the new Geodatabase Administration GP tools introduced at 10.1.
解决办法
1. Create STATE10 layer using the following command:
sdeimport -o create -t STATE10 -i 5251 -u sde -p sde -f co_state.sdx
2. Create another layer called STATEWY using the same command:
sdeimport -o create -t STATEWY -i 5251 -u sde -p sde -f wy_state.sdx
3. Convert STATEWY to a shape file.
From ArcCatalog, right click on STATEWY > Export > To Shapefile (Single or Multiple) or you can also use sde2shp command.
4. Once STATEWY is converted to a shp file, use "shp2sde -o append" command to append to STATE10 layer.
shp2sde -o append -l STATE10,shape -f WY.shp -u sde -p sde -i 5251
5. Now you will see both WY and CO in STATE10 layer. The only downside of this workaround is that you might have to repeat steps 2-4 for all the sdx files you have.