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 |