SDO_GEOR_ADMIN.registerGeoRasterObjects

Format

SDO_GEOR_ADMIN.registerGeoRasterObjects(table_name VARCHAR2 DEFAULT NULL);

Description

Registers the GeoRaster objects defined in the current schema or in all the schemas in the database.

Parameters

table_name

Name of the GeoRaster table.

• The GeoRaster table name to be provided in the format, <schema_name>.<table_name>. If the <schema_name> is omitted, then the current user’s schema name is used.

• If the table_name parameter is specified, only the GeoRaster objects in the specified table are registered. If this parameter is NULL, all the GeoRaster objects are registered.

Usage Notes

If you execute this procedure as a user with DBA role, then the procedure either registers all the GeoRaster objects defined in all the schemas in the database, or registers the GeoRaster objects in the specified table and schema. Otherwise, it only registers the GeoRaster objects defined in the current schema. If the table_name parameter is specified, only the GeoRaster objects in the specified table are registered.

If a schema is not enabled for GeoRaster, the GeoRaster objects in that schema are not registered.

Examples

The following example registers all GeoRaster objects defined in the current schema.

EXECUTE SDO_GEOR_ADMIN.registerGeoRasterObjects;

The following example registers all the GeoRaster objects defined in ‘TEST_TABLE1’ in the current schema.

EXECUTE SDO_GEOR_ADMIN.registerGeoRasterObjects('TEST_TABLE1');

The following example registers all the GeoRaster objects defined in ‘TEST_TABLE1’ in schema ‘SCOTT’. This can be performed by a user with DBA role.

EXECUTE SDO_GEOR_ADMIN.registerGeoRasterObjects('SCOTT.TEST_TABLE1');