Bug
Creating a spatial view using objectid as an alias name in –a option for a non-default field name (other than objectid column) gives an error.
| Bug ID Number | NIM057396 |
|---|---|
| Submitted | May 14, 2010 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 9.3.1 |
| Operating System | Windows OS |
| Operating System Version | 2003 |
| Version Fixed | 10.1 |
| Status | Fixed |
Additional Information
Fixed in 10.1 using the new create view workflow.Workaround
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.id8Steps to Reproduce
Bug ID: NIM057396
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App