My Oracle Support Banner

Using Temporary GeoRaster objects as Documented in GeoRaster Manual (Doc ID 2942871.1)

Last updated on MAY 19, 2023

Applies to:

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


In the 19c document GeoRaster Developer Guide, section 3.13 Maintaining Efficient Use of Tablespace by GeoRaster Objects the following text advises on the use of a temporary working raster data table (RDT) to hold intermittent results which leaves some questions:
1. What kind of work is required to move or copy the data, is a general INSERT as SELECT acceptable?
2. When is the time to delete the RDT?  The manual states when the RDT becomes unnecessary but does not refer to what kind of work result makes it unnecessary.
3, The work image is to move the remaining data, including intermittent data, to a temporary working raster data table, truncate the originally used raster data table, and save the space  If this is correct, is it okay to use a general INSERT SELECT for the work of moving the remaining data, including intermittent data, to a raster data table for temporary use?


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

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