6.18 SDO_NET.CREATE_SUBPATH_TABLE
Format
SDO_NET.CREATE_SUBPATH_TABLE( table_name IN VARCHAR2, geom_column IN VARCHAR2, storage_parameters IN VARCHAR2 DEFAULT NULL);
Description
Creates a subpath table.
Parameters
- table_name
-
Name of the subpath table.
- geom_column
-
For a spatial network, name of the column containing the geometry objects associated with the subpaths.
- storage_parameters
-
Physical storage parameters used internally to create the subpath table (described in Node Table). Must be a valid string for use with the CREATE TABLE statement. For example:
TABLESPACE tbs_3 STORAGE (INITIAL 100K NEXT 200K)
. If you do not specify this parameter, the default physical storage values are used.
Usage Notes
The subpath table is described in Subpath Table.
To use subpaths with a network, you must create one or more path tables and their associated path-link tables.
Examples
The following example creates a subpath table named ROADS_SUBPATHS that contains a geometry column named SUBPATH_GEOMETRY.
EXECUTE SDO_NET.CREATE_SUBPATH_TABLE('ROADS_SUBPATHS', 'SUBPATH_GEOMETRY');
Parent topic: SDO_NET Package Subprograms