SDO_UTIL.DISABLE_VECTORTILE_CACHE

Format

SDO_UTIL.DISABLE_VECTORTILE_CACHE(
  table_name     IN VARCHAR2,
  geom_col_name  IN VARCHAR2
);

Description

Disables a vector tile cache.

Parameters

table_name

Name of the table containing the information used to build the vector tiles (a geometry column and zero or more attribute columns).

geom_col_name

Name of the SDO_GEOMETRY type column in table_name which is used to build vector tiles.

Usage Notes

Note the following when calling SDO_UTIL.DISABLE_VECTORTILE_CACHE:

• Only the schema that enabled the cache is allowed to disable that cache.

• The table_name and geom_col_name parameters are used to remove caches’ information from SDO_VECTOR_TILE_CACHE$INFO and all of the caches’ data from SDO_VECTOR_TILE_CACHE$TABLE.

• When the last tile cache is disabled, both the SDO_VECTOR_TILE_CACHE$INFO and SDO_VECTOR_TILE_CACHE$TABLE tables will be empty. Note that the empty tables are not dropped but left intact to be used by future caches. However, you may drop these tables if desired after you ensure that they are empty.

• Once the cache is disabled, all calls to SDO_UTIL.GET_VECTORTILE will build the vector tiles from scratch and these are returned without caching the result.

Examples

The following example calls SDO_UTIL.DISABLE_VECTORTILE_CACHE to disable cache on the counties table.

-- Disable the cache on the COUNTIES table
EXEC SDO_UTIL.DISABLE_VECTORTILE_CACHE('counties', 'geom');