My Oracle Support Banner

How To Change The RASTERID (Doc ID 1632563.1)

Last updated on JANUARY 21, 2020

Applies to:

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


Have an actual set of Georaster and Raster Data Tables lets call it the CURRENT set

Receiving a new set of TIFF files and build a second set of Georaster and Raster Data Tables lets call it the NEW set.

Both the CURRENT and the NEW sets HAVE to be available at the same time for a period of time (2 days)

Then the CURRENT set will be "archived" but still has to be available, the NAMES of the tables have to change to some archived name for the CURRENT set. AND the NEW set has to change table names with the names of the CURRENT set.

Once the names are changed the application would expect the RASTERID to represent the same "TILE" as previous Georaster table but it does not. The customer wants to update RASTERID to have the same representation he had prior to the change in Tables.

How to change the RASTERID? which is in the Georaster table and also int he Raster Data table?


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.