6.13 SDO_NET.CREATE_NODE_TABLE
Format
SDO_NET.CREATE_NODE_TABLE( table_name IN VARCHAR2, geom_type IN VARCHAR2, geom_column IN VARCHAR2, cost_column IN VARCHAR2, no_of_hierarchy_levels IN NUMBER, is_complex IN BOOLEAN DEFAULT FALSE, storage_parameters IN VARCHAR2 DEFAULT NULL); or SDO_NET.CREATE_NODE_TABLE( table_name IN VARCHAR2, geom_type IN VARCHAR2, geom_column IN VARCHAR2, cost_column IN VARCHAR2, partition_column IN VARCHAR2, no_of_hierarchy_levels IN NUMBER, is_complex IN BOOLEAN DEFAULT FALSE, storage_parameters IN VARCHAR2 DEFAULT NULL);
Description
Creates a node table.
Parameters
- table_name
-
Name of the node table.
- geom_type
-
For a spatial network, specify a value indicating the geometry type of nodes:
SDO_GEOMETRY
for non-LRS SDO_GEOMETRY objects,LRS_GEOMETRY
for LRS SDO_GEOMETRY objects, orTOPO_GEOMETRY
for SDO_TOPO_GEOMETRY objects. (If thegeom_type
value is not spelled correctly, thegeom_column
column is not included in the table.) - geom_column
-
For a spatial network, the name of the column containing the geometry objects associated with the nodes.
- cost_column
-
Name of the column containing the cost values to be associated with the nodes.
- partition_column
-
Name of the column containing the partition ID values to be associated with the nodes.
- no_of_hierarchy_levels
-
Number of hierarchy levels for nodes in the network. (For an explanation of network hierarchy, see Network Hierarchy.)
- is_complex
-
Reserved for future use. Ignored for the current release.
- storage_parameters
-
Physical storage parameters used internally to create the <network-name>_NODE$ 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
This procedure has two formats, one without the partition_column
parameter and one with the partition_column
parameter.
The node table is described in Node Table.
Examples
The following example creates a node table named ROADS_NODES with a geometry column named NODE_GEOMETRY that will contain LRS geometries, no cost column, and a single hierarchy level.
EXECUTE SDO_NET.CREATE_NODE_TABLE('ROADS_NODES', 'LRS_GEOMETRY', 'NODE_GEOMETRY', NULL, 1);
Parent topic: SDO_NET Package Subprograms