English

Bug: When creating SDO_GEORASTER columns, ArcSDE creates geometry columns as LONG RAW

Description

In ArcSDE 9.2, when creating SDO_GEORASTER columns, ArcSDE creates geometry columns as LONG RAW.

Cause

The GEOMETRY_STORAGE parameter for the SDO_GEORASTER is set incorrectly to BLOB. It should be set to SDELOB. Since the parameter is an unknown value, ArcSDE ignores the parameter and creates the geometry column as the default LONG RAW.

Workaround

Use sdedbtune to correct the GEOMETRY_STORAGE parameter for the SDO_GEORASTER keyword. For details on using the sdedbtune command, consult the ArcSDE Administration Command Reference provided with ArcSDE or click on the link provided in the Related Information section of this article.


Code:
sdedbtune -o alter -k sdo_georaster -P geometry_storage -v sdelob

The corrected keyword setting is as follows:

##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 keyword"
COMMENT "Any general comment for SDO_GEORASTER keyword"
END

Related Information