Line 7: LOB (shape.points) represents the LOB item shape.points (the attribute named shape which is the ST_Geometry type).
Line 8: STORE AS streets_shape_seg represents the name of the LOB segment created for storing out-of-line LOB attributes.
Line 9: Represents the tablespace where the LOB segment is created. ENABLE STORAGE IN ROW indicates that the binary object should be stored in row when the number of bytes is < 4000. CHUNK 8K represents the size for LOB manipulation: the default size is the segment's block size. RETENTION represents the amount of time updated LOBs are maintained in automatic undo. The length of time is based on the init.ora parameter UNDO_RETENTION. CACHE represents whether the segment block should be in the SGA cache or not.
Line 10: Indicates the LOB segment's storage clause, the initial extent is 500M and each additional extent increases by 10%.
Line 11-12: INDEX represents the tablespace where the LOB segment's index is created. The STORAGE parameter sets the storage clause, the initial extent is 50M and each additional extent increases by 10%.
Line 13: Indicates the street's physical attributes, pctfree 10 defining 10% of the block is free for future inserts and initrans defining the number of initial transaction slots for concurrent transactions accessing the block.
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.