学步园

How does ArcSDE use Oracle Spatial?（arcsde怎么样使用oracle spatial）

ArcSDE supports Oracle Spatial or Oracle Locator for storing and managing
geometry in an Oracle database. To use it, you must have SDO_GEOMETRY specified
for the GEOMETRY_STORAGE parameter of one of your configuration keywords. （为了使用它，你必须要把SDO_Geometry指定为Geometry_storage参数中的一个关键字）If you
want to use Oracle Spatial geometry storage most of the time, specify
SDO_GEOMETRY for the GEOMETRY_STORAGE parameter in your DEFAULTS configuration
keyword. If you want to use it for only some datasets, utilize the SDO_GEOMETRY
keyword when creating each individual dataset.

Making Oracle Spatial your default geometry schema

When you first install the 9.3 ArcSDE component, ST_Geometry
is the default geometry storage type. The default settings for ArcSDE storage
are defined in the DBTUNE table by the GEOMETRY_STORAGE parameters. （当你首次安装ArcSDE component，ST_Geometry是默认的几何存储类型。ArcSDE存储的默认设置在DBTUNE中通过Geometry_Storage参数定义）
Changing the default ArcSDE geometry storage to use Oracle Spatial is
easy. For the DEFAULTS keyword, change the GEOMETRY_STORAGE parameter from
ST_GEOMETRY to SDO_GEOMETRY. （改变默认的ArcSDE几何存储而使用Oracle Spatial很简单。只要设置DEFAULT关键字，改变Geometry_Storage参数从ST_Geometry到SDO_Geometry）After the default GEOMETRY_STORAGE setting has been
changed to SDO_GEOMETRY, ArcSDE creates feature classes with SDO_GEOMETRY
columns by default.(在改变默认的Geometry_Storage为SDO_Geometry之后，ArcSDE创建的feature class使用SDO_Geometry字段存储)

NOTE: Use the sdedbtune administration command to alter DBTUNE
settings. For details on using the sdedbtune command, consult the ArcSDE
Administration Command Reference installed with ArcSDE.

ArcSDE for Oracle supports a number of different geometry storage
schemas—these different schemas can all be used together in the same database.
While there can only be one default geometry schema, individual tables can be
created using different geometry schemas.
If you want to store just some of your feature classes with the Spatial
Type for Oracle storage, you can specify the keyword SDO_GEOMETRY when you
create the feature class. If you do this, that particular feature class will be
created with an SDO_GEOMETRY column. In the dbtune file, the SDO_GEOMETRY
keyword appears as follows:

##SDO_GEOMETRY
GEOMETRY_STORAGE    "SDO_GEOMETRY"
ATTRIBUTE_BINARY    "BLOB"
RASTER_STORAGE	    "SDO_GEORASTER"
SDO_COMMIT_INTERVAL  1000
UI_TEXT          "User Interface text description for SDO_GEOMETRY"

COMMENT        "Any general comment for SDO_GEOMETRY keyword"

END