My Oracle Support Banner

Database Upgrade: Script to identify and convert 4-band JPEG compressed SDO_GEORASTER object (Doc ID 2960620.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Spatial and Graph - Version 19.1.0.0.0 to 21 [Release 12.2]
Information in this document applies to any platform.
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 compressed GeoRaster object needs to be either decompressed or re-blocked to 1-band raster blocks before upgrading to Oracle Database 23ai.

Purpose

Starting in 23ai, GeoRaster objects with 4-band JPEG compression is desupported.

This note provides the instructions to identify the 4-band JPEG compressed GeoRaster object and to accomplish the conversion from 4-band JPEG compressed GeoRaster object to uncompressed GeoRaster object or 1-band JPEG compressed GeoRaster object object in Oracle Database 19c and 21c. Follow the steps described below:

Scope

This information applies to any platform.

Details

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
Purpose
Scope
Details

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