How Enable GeoRaster Support on Oracle Database Schema

This article will guide you how to enable GeoRaster on Oracle Database. GeoRaster is a feature of Oracle Spatial that lets you store, index, query, analyze, and deliver raster image and gridded data and its associated metadata. GeoRaster provides Oracle Spatial data types and an object-relational schema. In a simple word, with GeoRaster we can store and analyze raster data within Oracle Database. We can store GeoTiff files in Oracle Database. You can follow this guide to enable GeoRaster on your Oracle Database regardless your operating system.

In order to follow this guide, you must have the Oracle Database installed on your system. If you are using the Oracle Autonomous Database, this guide will also work.

How to Enable GeoRaster at the Schema Level

First, we need to make sure that the user for the schema has the CREATE TRIGGER privilege. To do this, we need to connect to the database as a user with DBA privilege. Open Command Prompt (Windows) or Terminal in Linux and run sqlplus.

sqlplus / as sysdba

Now we need to connect to the pluggable database and then grant the CREATE TRIGGER to our user

ALTER SESSION SET CONTAINER=freepdb1;
GRANT CREATE TRIGGER TO Dhani;

Now exit sqlplus and re connect to the freepdb1 as the user for the schema. For example:

sqlplus Dhani/YourPassWord@//localhost:1521/freepdb1

Now run this statement

EXECUTE SDO_GEOR_ADMIN.enableGeoRaster;

Verify that GeoRaster is now enabled

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

At this time, we have successfully enabled GeoRaster support to our schema. Next we will learn how to upload raster file to Oracle Database. Stay tuned. For more information, please visit the official documentation below.

Enabling GeoRaster at the Schema Level