3.3 SDO_TOPO.DELETE_TOPO_GEOMETRY_LAYER
Format
SDO_TOPO.DELETE_TOPO_GEOMETRY_LAYER( topology IN VARCHAR2, table_name IN VARCHAR2, column_name IN VARCHAR2);
Description
Deletes a topology geometry layer from a topology.
Parameters
- topology
-
Topology from which to delete the topology geometry layer containing the topology geometries in the specified column. The topology must have been created using the SDO_TOPO.CREATE_TOPOLOGY procedure.
- table_name
-
Name of the table containing the column specified in
column_name
. - column_name
-
Name of the column containing the topology geometries in the topology geometry layer to be deleted from the topology.
Usage Notes
This procedure deletes data associated with the specified topology geometry layer from the <topology-name>_RELATION$ table (described in Relationship Information Table). If this procedure is deleting the only remaining topology geometry layer from the topology, it also deletes the <topology-name>_RELATION$ table.
This procedure automatically performs a commit operation, and therefore it cannot be rolled back.
Examples
The following example deletes the topology geometry layer that is based on the geometries in the FEATURE column of the LAND_PARCELS table from the topology named CITY_DATA
. (The example refers to definitions and data from Topology Built from Topology Data.)
EXECUTE SDO_TOPO.DELETE_TOPO_GEOMETRY_LAYER('CITY_DATA', 'LAND_PARCELS', 'FEATURE');
Parent topic: SDO_TOPO Package Subprograms