Bug
Tables like st_* that are being shared both by sde and user-schema geodatabase need to be documented.
| Bug-ID-Nummer | NIM041161 |
|---|---|
| Eingereicht | January 5, 2009 |
| Zuletzt geändert | April 2, 2025 |
| Gilt für | ArcSDE/Enterprise Geodatabase |
| Gefunden in Version | 9.3 |
| Behoben in Version | 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.Schritte zur Reproduzierung
Bug-ID: NIM041161
Software:
- ArcSDE/Enterprise Geodatabase
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen