Format

SDO_GEOR_ADMIN.registerGeoRasterColumns(table_name VARCHAR2 DEFAULT NULL);

Description

Creates DML triggers for all GeoRaster columns 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 columns in the specified table are registered. If this parameter is NULL, all the GeoRaster columns are registered.

Usage Notes

You should not normally need to execute this procedure. You should execute it only if some error or other condition has resulted in GeoRaster columns without associated DML triggers.

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

If a schema is not enabled for GeoRaster, the DML triggers are not created in that schema.

Examples

The following example creates DML triggers for all GeoRaster columns defined in the current schema.

EXECUTE sdo_geor_admin.registerGeoRasterColumns;

The following example creates DML triggers for the GeoRaster columns in the table TEST_TABLE1 in schema GEOR. This can be executed either under user GEOR or under a user with DBA role.

EXECUTE sdo_geor_admin.registerGeoRasterColumns('GEOR.TEST_TABLE1');