NIM057396 for ArcSDE/Enterprise Geodatabase

漏洞 ID 编号	NIM057396
已提交	May 14, 2010
上次修改时间	April 2, 2025
适用范围	ArcSDE/Enterprise Geodatabase
找到的版本	9.3.1
操作系统	Windows OS
操作系统版本	2003
修正版本	10.1
状态	Fixed

附加信息

Fixed in 10.1 using the new create view workflow.

解决办法

1. Create a spatial view using sdetable –o create_view command and do not provide ‘objectid’ as alias in –a option for a field name as following:H:\>sdetable -o create_view -T test_view -t tview,t2 -c tview.shape,t2.id8 -a shape,object_test -w tview.objectid=t2.id8 -i sde:oracle10g -u sde -p sde@domain2. Connect in sqlplus as SDE user account. Run the following command to create/replace the view. This would create objectid alias for non default column:SQL> create or replace view test_view ("SHAPE","OBJECTID","OBJECTID_TEST") as select a.shape, b.ID8, a.objectid from tview a,t2 b where a.OBJECTID=b.id8