How To Change The RASTERID (Doc ID 1632563.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Goal

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?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms