Default configuration keywords specific to Oracle

In addition to the default DBTUNE keywords common to all DBMSs for ArcSDE 9 and higher that were listed in the topic Types of configuration keywords, there are keywords that are specific to ArcSDE for Oracle and Oracle Spatial. These are listed here.

As mentioned in the topic The DEFAULTS keyword in Oracle, if you specify a keyword that only has a few parameters, the rest of the parameters are read from the DEFAULTS configuration keyword. Therefore, if you specify SDELOB when you create a feature class in a geodatabase in Oracle, the software uses the values for GEOMETRY_STORAGE, ATTRIBUTE_BINARY, and RASTER_STORAGE parameters from the SDELOB keyword, then goes to the DEFAULTS keyword for values for all the other parameters, such as B_STORAGE and UNICODE_STRING.

If you need additional keywords, you must create them. This is done using the sdedbtune command line tool. The command line tools are a separate installation beginning with ArcGIS 10.1, and can be downloaded from the Esri Customer Care portal.

SDELOB

This keyword can be used to specify that the feature class being created use SDELOB geometry storage.

##SDELOB
GEOMETRY_STORAGE    "SDELOB"
ATTRIBUTE_BINARY    "BLOB"
RASTER_STORAGE	    "BLOB"

UI_TEXT             "User Interface text description for SDELOB"

COMMENT             "Any general comment for SDELOB keyword"

END

SDO_GEOMETRY

This keyword can be used to specify that the feature class should be created with an SDO_Geometry column.

##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

WKB_GEOMETRY

Specifying this keyword creates the feature class with a Well-Known Binary geometry column.

##WKB_GEOMETRY
GEOMETRY_STORAGE    "OGCWKB"
UI_TEXT             "User Interface text description for OGC WKB"

END

SDO_GEORASTER

This keyword can be specified when creating rasters if you want to use SDO_Georaster storage.

##SDO_GEORASTER
GEOMETRY_STORAGE    "SDELOB"
RASTER_STORAGE      "SDO_GEORASTER"
ATTRIBUTE_BINARY    "BLOB"
RDT_STORAGE         "PCTFREE 0 INITRANS 4"
#                    TABLESPACE <RDT Table tablespace name>
RDT_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4
#                    TABLESPACE <RDT Composite index tablespace name>
                     STORAGE ( INITIAL 409600) NOLOGGING"
UI_TEXT             "User Interface text description for SDO_GEORASTER"
COMMENT             "Any general comment for SDO_GEORASTER keyword"
END

Composite keywords

If you want to create a topology, terrain, or network that uses a geometry storage type other than what is stored under the DEFAULTS keyword, you need to specify keywords that contain the desired geometry storage. For example, if you create a roads feature class in an Oracle database using the SDO_GEOMETRY keyword, when you create a network that involves that roads feature class, the network must also use SDO_GEOMETRY. For that, specify the NETWORK_SDOGEOMETRY keyword.

See Composite keywords and geometry storage for details on setting up network, terrain, and topology keywords for nondefault geometry types.

The following are the default composite keywords that correspond to the geometry storage keywords:

• NETWORK_SDELOB

  Use this keyword when creating a network built from feature classes that use SDELOB geometry storage.

• TERRAIN_SDELOB

  Use this keyword when creating a terrain built from feature classes that use SDELOB geometry storage.

• TOPOLOGY_SDELOB

  Use this keyword when creating a topology that includes feature classes that use SDELOB geometry storage.

• NETWORK_SDOGEOM

  Use this keyword when creating a network built from feature classes that use SDO_GEOMETRY storage.

• TERRAIN_SDEOGEOM

  Use this keyword when creating a terrain built from feature classes that use SDO_GEOMETRY storage.

• TOPOLOGY_SDOGEOM

  Use this keyword when creating a topology that includes feature classes that use SDO_GEOMETRY storage.