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
Parent topic: SDO_GEOR_ADMIN Package Reference