Format

SDO_GEOR_ADMIN.isUpgradeNeeded() RETURN SDO_STRING2_ARRAY;

Description

Checks the GeoRaster system data entries and GeoRaster data for the current schema or for all the schemas in the database.

Parameters

None.

Usage Notes

This function returns an array of comma-delimited list of GeoRaster system data entries and GeoRaster columns and objects that are invalid. It can report errors such as the following:

• System data entry error, the RDT name is not unique.

• System data entry error, the RDT/RID pair is not unique.

• System data entry error, the GeoRaster table does not exist.

• System data entry error, the GeoRaster column does not exist.

• System data entry error, the GeoRaster object does not exist.

• The GeoRaster object is non-empty or nonblank, but the RDT does not exist.

• Duplicate GeoRaster objects exist (that is, one or more non-unique combinations of RDT and raster ID).

• There is a non-registered pair of (GeoRaster column, GeoRaster object).

If you execute this function as a user with DBA role, then the function checks the GeoRaster system data entries and GeoRaster data for all the schemas in the database. Otherwise, it only checks the GeoRaster system data entries and GeoRaster data for the current schema.

Examples

The following example checks the GeoRaster system data entries and GeoRaster data. It assumes that you are connected as a user with DBA role.

SELECT * FROM THE (SELECT SDO_GEOR_ADMIN.isUpgradeNeeded FROM DUAL);
 
COLUMN_VALUE
--------------------------------------------------------------------------------
The following GeoRaster columns aren't registered:
     SCHEMA:GEOR_TEST TABLE:TABLE1 COLUMN:GEOR
The following GeoRaster objects aren't registered:
     SCHEMA:GEOR_TEST TABLE:TABLE1 COLUMN:GEOR RDT:RDT RID:3
     SCHEMA:GEOR_TEST TABLE:TABLE1 COLUMN:GEOR RDT:RDT RID:4