Bug
Spatial Type for Oracle: When creating the st_geometry type and subtypes must set the Oracle oid property.
| Bug ID Number | NIM035228 |
|---|---|
| Submitted | May 14, 2008 |
| Last Modified | June 5, 2024 |
| Applies to | No Product Found |
| Version found | 9.3 |
| Version Fixed | 9.3 |
| Status | Fixed |
Description
Oracle types require an OID property value to uniquely identify the type. When creating a type, there is an OID clause for establishing type equivalence of identical objects in more than one database.ArcSDE 9.2 does not set the OID property value when creating a type.
Cause
When a type is created, the OID property value must be specified if the type is going to participate in Oracle replication or allow tables with the type attribute to be exported and imported between Oracle instances. If the OID is not set in the command during the type's creation, Oracle automatically generates a globally unique OID value.Unfortunately, the limitations when a type OID value is not set when creating a type are not clearly documented by Oracle.
Oracle does not provide the ability to ALTER existing types to set an OID value.
Workaround
There is no workaround to the problem once an ArcSDE instance has been installed.Steps to Reproduce
Bug ID: NIM035228
Software:
- No Product Found
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