3 GeoRaster Database Creation and Management

This chapter describes how to perform important GeoRaster database creation and management operations. A typical workflow to build and manage a GeoRaster database consists of most or all of the steps described.

After you enable GeoRaster for all schemas that will use the feature, create the GeoRaster objects, load the data, and validate the GeoRaster objects, you can perform the remaining operations in any order, depending on your application needs. You may also be able to skip certain operations.

Some operations can be performed using SQL, and some operations must be performed using PL/SQL blocks. You must update the GeoRaster object after you insert, update, reformat, compress, decompress, or delete the metadata or cell data of the GeoRaster object and before you commit the changes (see Updating GeoRaster Objects Before Committing). For some examples of these operations, see the demo files described in GeoRaster PL/SQL and Java Demo Files and the examples in SDO_GEOR Package Reference.

See also the operations in GeoRaster Data Query and Manipulation.

Other chapters in this book cover advanced topics (Raster Algebra and Analytics and Image Processing and Virtual Mosaic), and provide detailed reference information about GeoRaster PL/SQL packages (SDO_GEOR Package Reference, SDO_GEOR_ADMIN Package Reference, SDO_GEOR_AGGR Package Reference, SDO_GEOR_RA Package Reference, and SDO_GEOR_UTL Package Reference).