13.24 SDO_GEOR_UTL.renameRDT
Format
SDO_GEOR_UTL.renameRDT( oldRDTs VARCHAR2, newRDTs VARCHAR2 DEFAULT NULL);
Description
Renames one or more existing registered raster data tables owned by the current user, and updates the GeoRaster system data and all affected GeoRaster objects to reflect the new names.
Parameters
- oldRDTs
-
Name of the registered raster data table or tables to be renamed. For multiple tables, use a comma-delimited list.
- newRDTs
-
New names to be assigned to the raster data table or tables that are specified in
oldRDTs
. For multiple tables, use a comma-delimited list with an order exactly reflecting the names inoldRDTs
. If this parameter is null, GeoRaster assigns a unique new name to each input raster data table.
Usage Notes
If one or more registered raster data tables owned by different users have the same name, you can use this procedure or the SDO_GEOR_UTL.makeRDTNamesUnique procedure, or both, to eliminate the duplication.
Before using this procedure, you must connect to the database as the owner of the raster data table or tables. You cannot use this procedure to rename a raster data table owned by another user.
If any table in oldRDTs
is not included in the GeoRaster system data, it is ignored.
If any table in newRDTs
conflicts with a name in the GeoRaster system data or with the name of another object owned by the current user, an exception is raised.
This procedure is not transactional, and the result cannot be rolled back.
Examples
The following example renames the registered raster data tables RDT_1 and RDT_2 to ST_RDT_1 and ST_RDT_2, respectively.
EXECUTE sdo_geor_utl.renameRDT('RDT_1,RDT_2','ST_RDT_1,ST_RDT_2');
Parent topic: SDO_GEOR_UTL Package Reference