8.3 SDO_GEOR_ADMIN.enableGeoRaster

Format

SDO_GEOR_ADMIN.enableGeoRaster();

Description

Enables the GeoRaster feature for the current schema.

Parameters

None.

Usage Notes

The session user that calls the SDO_GEOR_ADMIN.enableGeoRaster() procedure must be same as the database user for the current schema.

The user must have the CREATE TRIGGER privilege.

Examples

The following example checks if GeoRaster is enabled for the current schema (before it is enabled), then enables GeoRaster for the current schema, and then again checks if GeoRaster is enabled for the current schema.

SQL> SELECT /*+ NO_RESULT_CACHE */ SDO_GEOR_ADMIN.isGeoRasterEnabled FROM DUAL;

ISGEORASTERENABLED
------------------------------------------------------------------------------
FALSE

SQL> EXECUTE SDO_GEOR_ADMIN.enableGeoRaster;

PL/SQL procedure successfully completed.

SQL> SELECT /*+ NO_RESULT_CACHE */ SDO_GEOR_ADMIN.isGeoRasterEnabled FROM DUAL;

ISGEORASTERENABLED
------------------------------------------------------------------------------
TRUE