How does ArcSDE use Oracle Spatial? arcsde怎麼使用oracle spatial

文章目錄

• Making Oracle Spatial your default geometry schema

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 schemaWhen 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_GEOMETRYGEOMETRY_STORAGE    "SDO_GEOMETRY"ATTRIBUTE_BINARY    "BLOB"RASTER_STORAGE    "SDO_GEORASTER"SDO_COMMIT_INTERVAL  1000UI_TEXT          "User Interface text description for SDO_GEOMETRY"COMMENT        "Any general comment for SDO_GEOMETRY keyword"END