6.12 SDO_NET.CREATE_LRS_TABLE
Format
SDO_NET.CREATE_LRS_TABLE( table_name IN VARCHAR2, geom_column IN VARCHAR2, storage_parameters IN VARCHAR2 DEFAULT NULL);
Description
Creates a table for storing Oracle Spatial linear referencing system (LRS) geometries.
Parameters
- table_name
-
Name of the table containing the geometry column specified in
geom_column
. - geom_column
-
Name of the column (of type SDO_GEOMETRY) to contain geometry objects.
- storage_parameters
-
Physical storage parameters used internally to create the LRS 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 creates a table named table_name
with two columns: GEOM_ID of type NUMBER and geom_column
of type SDO_GEOMETRY.
Although the created table does not need to be used to store LRS geometries, the procedure is intended as a convenient method for creating a table to store such geometries. You will probably want to modify the table to add other columns before you store data in the table.
Examples
The following example creates a table named HIGHWAYS with a geometry column named GEOM.
EXECUTE SDO_NET.CREATE_LRS_TABLE('HIGHWAYS', 'GEOM'); PL/SQL procedure successfully completed. DESCRIBE highways Name Null? Type ----------------------------------------- -------- ---------------------------- GEOM_ID NOT NULL NUMBER GEOM MDSYS.SDO_GEOMETRY
Parent topic: SDO_NET Package Subprograms