Tables like st_* that are being shared both by sde and user-schema geodatabase need to be documented.
上次发布: August 25, 2014ArcSDE/Enterprise Geodatabase
漏洞 ID 编号
NIM041161
已提交
January 5, 2009
上次修改时间
April 2, 2025
适用范围
ArcSDE/Enterprise Geodatabase
找到的版本
9.3
修正版本
N/A
状态
Fixed
此漏洞已得到修复。 有关详细信息,请参阅“版本修复”和“其他信息”(如果适用)。
解决办法
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.