NIM009511 for No Product Found

Bug ID Number	NIM009511
Submitted	June 5, 2007
Last Modified	April 2, 2025
Applies to	No Product Found
Version found	9.2
Version Fixed	9.3
Status	Fixed

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