Format

SDO_UTIL.PURGE_VECTORTILE_CACHE(
  table_name     IN VARCHAR2                
); 

Description

Purges all vector tiles generated from data contained in the specified table.

Parameters

table_name

Name of the table or view whose containing vector tiles are purged from the cache.

Usage Notes

Generally there is only a single tile cache associated with a table. However, if a table has multiple geometry columns, then it can also have multiple tile caches. In such a case, calling SDO_UTIL.PURGE_VECTORTILE_CACHE will remove all vector tiles from all caches associated with the table, but the caches will remain enabled.

Examples

-- Enable a cache on the Counties table using the geometry column
EXEC SDO_UTIL.ENABLE_VECTORTILE_CACHE('counties', 'geom');

-- Compute a vector tile
SELECT SDO_UTIL.GET_VECTORTILE(TABLE_NAME=>'COUNTIES', GEOM_COL_NAME=>'GEOM',
                                 TILE_ZOOM=>8, TILE_X=>73, TILE_Y=>97,
                                 ATT_COL_NAMES=>sdo_string_array('COUNTY','LANDSQMI'))
  FROM dual;

-- Show the cache now contains a vector tile
SELECT COUNT(*) FROM SDO_VECTOR_TILE_CACHE$TABLE WHERE table_name='counties';

-- Purge the tile cache for COUNTIES
EXEC SDO_UTIL.PURGE_VECTORTILE_CACHE('counties');

-- Show that the cache is still enabled
SELECT * FROM SDO_VECTOR_TILE_CACHE$INFO WHERE table_name='counties';

-- Verify that the cached tiles are purged from the cache
SELECT COUNT(*) FROM SDO_VECTOR_TILE_CACHE$TABLE WHERE table_name='counties';