6.16 SDO_NET.CREATE_PATH_TABLE
Format
SDO_NET.CREATE_PATH_TABLE( table_name IN VARCHAR2, geom_column IN VARCHAR2, storage_parameters IN VARCHAR2 DEFAULT NULL);
Description
Creates a path table.
Parameters
- table_name
-
Name of the path table.
- geom_column
-
For a spatial network, name of the column containing the geometry objects associated with the paths.
- storage_parameters
-
Physical storage parameters used internally to create the path 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 path table is described in Path Table.
To use paths with a network, after you create the path table, you must create the path-link table using the SDO_NET.CREATE_PATH_LINK_TABLE procedure, and populate the path-link table.
Examples
The following example creates a path table named ROADS_PATHS that contains a geometry column named PATH_GEOMETRY.
EXECUTE SDO_NET.CREATE_PATH_TABLE('ROADS_PATHS', 'PATH_GEOMETRY');
Parent topic: SDO_NET Package Subprograms