3.4 SDO_TOPO.DROP_TOPOLOGY
Format
SDO_TOPO.DROP_TOPOLOGY( topology IN VARCHAR2);
Description
Deletes a topology.
Parameters
- topology
-
Name of the topology to be deleted. The topology must have been created using the SDO_TOPO.CREATE_TOPOLOGY procedure.
Usage Notes
This procedure deletes the <topology-name>_EDGE$, <topology-name>_NODE$, <topology-name>_FACE$, <topology-name>_NODE$, <topology-name>_RELATION$, and <topology-name>_HISTORY$ tables (described in Topology Data Model Tables).
If there are no topology layers associated with the topology, the topology is removed from the Spatial metadata.
This procedure automatically performs a commit operation, and therefore it cannot be rolled back.
A database user that owns a topology cannot be deleted. Therefore, before you can use the DROP USER ... CASCADE statement on a database user that owns a topology, you must connect as that user and execute the SDO_TOPO.DROP_TOPOLOGY procedure.
An exception is raised if the topology contains any topology geometries from any topology geometry layers. If you encounter this exception, delete all topology geometry layers in the topology using the SDO_TOPO.DELETE_TOPO_GEOMETRY_LAYER procedure for each topology geometry layer, and then drop the topology.
Examples
The following example drops the topology named CITY_DATA
. (The example refers to definitions and data from Topology Built from Topology Data.)
EXECUTE SDO_TOPO.DROP_TOPOLOGY('CITY_DATA');
Parent topic: SDO_TOPO Package Subprograms