How To Rename Georaster And Raster Data Tables

(Doc ID 1632541.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.

Symptoms

Need steps to rename Raster Data Tables and Georaster Table.

Have an actual set of Georaster and Raster Data Tables lets call it the CURRENT set
Receive 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 issue here is that 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.

In summary we need a way to change the names of the Georaster and the Raster Data tables.

Cause

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