Frequently asked question
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 lob_seg ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE
10 STORAGE (INITIAL 500M PCTINCREASE 10)
11 INDEX
12 (TABLESPACE lob_seg STORAGE (INITIAL 50M PCTINCREASE 10)))
13 PCTFREE 10 INITRANS 4
14 TABLESPACE user_data STORAGE (INITIAL 1M PCTINCREASE 0);
Table created.
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 lob_seg ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE
10 STORAGE (INITIAL 500M PCTINCREASE 10))
11 PCTFREE 10 INITRANS 4
12 TABLESPACE user_data STORAGE (INITIAL 1M PCTINCREASE 0);
Table created.
Note:
See Oracle's documentation in the Related Information below for additional information.
Get help from ArcGIS experts
Download the Esri Support App