Bug
Tables like st_* that are being shared both by sde and user-schema geodatabase need to be documented.
| Bug ID Number | NIM041161 |
|---|---|
| Submitted | January 5, 2009 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 9.3 |
| Version Fixed | N/A |
| Status | Fixed |
Workaround
In the web help document ST_Geometry storage in Oracle:http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?id=2682&pid=2668&topicname=ST_Geometry_storage_in_OracleMetadata schemaThe spatial type for Oracle types and metadata tables are owned by the SDE schema. The schema definition is the base table description for metadata tables used to define and describe the type column/table, spatial index, and spatial references information. The term type refers to the ST_Geometry spatial type. Spatial index refers to the ST_Spatial_Index domain index. All type and domain index type definitions, packages, and metadata tables are created in the SDE schema.In web help document Using multiple geodatabases in Oracle:http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/using_-2001045921.htmMultiple geodatabases in one Oracle databaseYou can create multiple geodatabases in one Oracle database. When you do this, you create a geodatabase in the schema of a user other than SDE. These geodatabases contain their own ArcSDE and geodatabase system tables. There can be only one geodatabase per user schema. Geodatabases in the user's schema run concurrently with one master geodatabase that is stored in the SDE schema. The geodatabase in the SDE schema is always the master geodatabase and contains a table (SDE.INSTANCES) that keeps track of all the other geodatabases in the Oracle database. The SDE schema also contains the ST_Geometry type, its subtypes and functions, and the system tables it uses, such as ST_SPATIAL_REFERENCES.Steps to Reproduce
Bug ID: NIM041161
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