My Oracle Support Banner

Script to identify and convert 4-band JPEG compressed SDO_GEORASTER object (Doc ID 2992512.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Spatial and Graph - Version 23ai Beta Only and later
Information in this document applies to any platform.

Goal

The issue described in this document might be encountered after importing GeoRaster tables from Oracle database 21c or older version, or after upgrading an Oracle database version 21c or older version to Oracle database version 23ai or later.


If the imported GeoRaster objects have 4-band raster blocks and were JPEG compressed, or the upgraded database has GeoRaster objects with JPEG compressed 4-band raster blocks, these GeoRaster objects become invalid and cannot be accessed in Oracle Database 23ai and later versions. The SDO_GEOR.validateGeoRaster() call on these objects will return the following error:
13440: invalid compression type JPEG-F/JPEG-B for bandBlockSize=4.

Oracle Spatial GeoRaster used to support JPEG compression on 1-band, 3-band and 4-band raster blocks. Starting with Oracle release 23ai, JPEG compression is only supported on 1-band and 3-band raster blocks. Thus any 4-band JPEG compression GeoRaster object needs to be either decompressed or re-blocked to 1-band raster blocks in order to be accessed in Oracle Database 23ai.

This note provides instructions on converting the 4-band JPEG compressed GeoRaster objects into valid GeoRaster objects.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.