English

FAQ: What is the ArcSDE for Oracle raster storage parameter?

Question

What is the ArcSDE for Oracle raster storage parameter?

Answer

Prior to the ArcSDE 9.2 for Oracle release the raster storage parameter was called 'RASTER_BINARY_TYPE'. This storage parameter allowed the BLOCK_DATA column of the raster blocks table (SDE_BLK_<N>) to be stored as either a LONG RAW or a BLOB column.

The default storage at the ArcSDE 9.1 for Oracle release was LONG RAW. However, if the raster data needs to be stored in a BLOB column, that can be indicated by setting the RASTER_BINARY_TYPE storage parameter to BLOB and adding it to a DBTUNE keyword, such as SDELOB. In the example below, the ArcSDE 9.1 raster storage parameter has been added to the SDELOB keyword accompanied by the geometry and attribute binary storage parameter.

##SDELOB 
ATTRIBUTE_BINARY "BLOB"
GEOMETRY_STORAGE "SDELOB"
RASTER_BINARY_TYPE “BLOB”
END

At ArcSDE 9.2 for Oracle, the raster storage parameter was renamed to RASTER_STORAGE. Although it is still supported, the DBTUNE keywords that include the RASTER_BINARY_TYPE storage parameter should be updated and renamed to RASTER_STORAGE.

The default raster storage for ArcSDE 9.2 for Oracle is BLOB. To change from the default storage type, set the raster storage parameter RASTER_STORAGE in the DBTUNE configuration keyword that will be used and set it to the appropriate storage type. At ArcSDE 9.2 for Oracle, there are three possible raster storage types: LONG RAW, BLOB, and SDO_GEORASTER.

In the example below, the raster storage parameter RASTER_STORAGE is set to BLOB in the SDELOB keyword and is accompanied by the geometry and attribute binary storage parameters.

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

To update the DBTUNE table with the changes made to the dbtune file, use the sdedbtune command with the import operation (as shown below).

C:\> sdedbtune -o import -f C:\ArcGIS\ArcSDE\ora10gexe\etc\dbtune.sde -i 5151 -u sde -p sde11g -N

ArcSDE 9.3 for Oracle11g Build 508 Thu Apr 17 12:23:18 2008
Attribute Administration Utility
-----------------------------------------------------

Successfully imported from file "dbtune.sde"

Note:
Oracle does not allow the creation of a table with a LONG RAW column at Oracle11G. However, Oracle will continue to support existing LONG RAW columns that were created in prior releases of Oracle.