Set storage parameters creating an Oracle table with ST_Geometry

Summary

When creating a table with an ST_Geometry attribute using Structured Query Language (SQL), one can specify the storage parameters for the binary ST_Geometery points' attribute.

Instructions provided describe how Oracle's CREATE TABLE command provides the ability to set a LOB segment's name and specific properties for the LOB and storage parameters.

Procedure

Code:
SQL> CREATE TABLE streets 
  2    (objectid    NUMBER(38) NOT NULL,
  3     name        VARCHAR2(64) NOT NULL,
  4     laddr       NUMBER(9),
  5     raddr       NUMBER(9),
  6     shape       st_geometry)
  7    LOB (shape.points) 
  8    STORE AS streets_shape_seg
  9     (TABLESPACE user_data ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE
 10    STORAGE (INITIAL 500M PCTINCREASE 10)
 11    INDEX
 12     (TABLESPACE lob_idx STORAGE (INITIAL 50M PCTINCREASE 10)))
 13    PCTFREE 10 INITRANS 4
 14    TABLESPACE user_data STORAGE (INITIAL 1M PCTINCREASE 0);

Table created.

Warning:
The LOB segment name (Line 8) must be unique in the user's schema. No two segments, such as tables or indexes, may share the same name.

Note:
See Oracle's documentation for additional information.