3.9 SDO_TOPO.PREPARE_FOR_EXPORT
Format
SDO_TOPO.PREPARE_FOR_EXPORT( topology IN VARCHAR2);
Description
Prepares a topology to be exported to another database.
Parameters
- topology
-
Name of the topology to be prepared for export. The topology must have been created using the SDO_TOPO.CREATE_TOPOLOGY procedure.
Usage Notes
This procedure prepares the specified topology in the current database (the source database) to be exported to another database (the target database).
This procedure creates a table in the current schema with a table name in the format <topology-name>_EXP$. This table contains the same columns as the USER_SDO_TOPO_INFO and ALL_SDO_TOPO_INFO views. These columns are described in Table 1-8 in xxx_SDO_TOPO_INFO Views.
Before calling this procedure, connect to the database as the owner of the topology.
For information about exporting and importing topologies, including the steps to be followed, see Exporting and Importing Topology Data.
Examples
The following example prepares the topology named CITY_DATA
for export to a target database. (The example refers to definitions and data from Topology Built from Topology Data.)
EXECUTE SDO_TOPO.PREPARE_FOR_EXPORT('CITY_DATA');
Parent topic: SDO_TOPO Package Subprograms