Maintaining GeoRaster Objects and System Data in the Database

Although GeoRaster provides strict internal database mechanism to prevent the creation of invalid GeoRaster objects and system data, sometimes such GeoRaster objects and system data may exist in the database. This happens if the GeoRaster DML trigger on a GeoRaster column is missing or after some user errors in operations on GeoRaster system data. Examples of such invalid objects and system data include the following:

• An entry in the GeoRaster system data views (xxx_SDO_GEOR_SYSDATA, described in GeoRaster System Data Views (xxx_SDO_GEOR_SYSDATA)) refers to a nonexistent GeoRaster table or column.

• Two or more GeoRaster objects have the same pair of RDT name and raster ID values.

• Some GeoRaster objects, tables, columns, or RDTs not registered.

• An RDT name is not unique.

• A GeoRaster object is non-empty or nonblank, but an associated RDT does not exist.

For regular maintenance, or maintenance after a database upgrade, call the following functions or procedures to check and correct any possible errors:

• Call SDO_GEOR_ADMIN.isGeoRasterEnabled to check if GeoRaster is enabled in a schema. If GeoRaster is not enabled in the schema, call SDO_GEOR_ADMIN.enableGeoRaster.

• Call SDO_GEOR_ADMIN.checkSysdataEntries to check if there are any invalid system data entries. If there are invalid system data entries, call SDO_GEOR_ADMIN.maintainSysdataEntries to maintain the entries. If you connect as a user with DBA role, these functions will check or maintain the GeoRaster system data entry for all schemas. Otherwise, these functions only check or maintain the GeoRaster system data for the current schema.

• Call SDO_GEOR_ADMIN.listGeoRasterColumns ('UNREGISTERED') to check if there are any unregistered GeoRaster columns. If there are unregistered GeoRaster columns, call SDO_GEOR_ADMIN.registerGeoRasterColumns to register these columns.

• Call SDO_GEOR_ADMIN.listGeoRasterObjects ('UNREGISTERED') to check if there are any unregistered GeoRaster objects. If there are unregistered GeoRaster objects, call SDO_GEOR_ADMIN.registerGeoRasterObjects to register these objects.

• Call SDO_GEOR_ADMIN.listDanglingRasterData to check if there is any dangling raster data in raster data table (RDT). The dangling raster data can be deleted by deleting the records in the raster data table.

See the reference and detailed usage information about these procedures and functions in SDO_GEOR_ADMIN Package Reference.