下面我们以将DEM数据存放为例进行说明。
1.建立存放DEM数据的表空间DEMData和存放DEM数据索引的表空间DEMIndex。
将数据存放表空间和索引表空间分开能够提高数据检索和浏览效率。
A：用以下语句创建存放DEM数据的DEMData表空间
CREATE SMALLFILE TABLESPACE DEMData DATAFILE 'D:\APP\STUDENT\CehuiZhuanye\DEMDataBase\DEMData.dbf'
SIZE 10240M AUTOEXTEND ON NEXT 10240M MAXSIZE UNLIMITED LOGGING EXTENT
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
B：用以下语句创建存放DEM数据索引的DEMIndex表空间
CREATE SMALLFILE TABLESPACE DEMIndex DATAFILE 'D:\APP\STUDENT\CehuiZhuanye\DEMDataBase\DEMIndex.dbf'
SIZE 1024M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED LOGGING EXTENT
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
2.在SDE文件dbtune中添加如下关键字“KeyWord”。
Dbtune文件在%SDEHOME/etc/dbtune.sde 中。
##DEMDataBase
GEOMETRY_STORAGE "ST_GEOMETRY"
ATTRIBUTE_BINARY "BLOB"
RASTER_STORAGE "BLOB"
UI_TEXT "User Interface text description for DEMDataBase keyword"
COMMENT "Any general comment for DEMDataBase keyword"
S_STORAGE "PCTFREE 10 PCTUSED 40 INITRANS 4 TABLESPACE DEMData"
S_INDEX_ALL "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex"
B_STORAGE "PCTFREE 10 PCTUSED 40 INITRANS 4 TABLESPACE DEMData "
B_INDEX_ROWID "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex"
B_INDEX_USER "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
B_INDEX_RASTER "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
B_INDEX_SHAPE "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
B_INDEX_TO_DATE "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex"
B_INDEX_XML "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
A_STORAGE "PCTFREE 10 PCTUSED 40 INITRANS 4 TABLESPACE DEMData "
A_INDEX_ROWID "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
A_INDEX_SHAPE "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
A_INDEX_STATEID "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
A_INDEX_USER "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
A_INDEX_XML "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
D_STORAGE "PCTFREE 10 PCTUSED 40 INITRANS 4 TABLESPACE DEMData"
D_INDEX_STATE_ROWID "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
D_INDEX_DELETED_AT "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
RAS_STORAGE "PCTFREE 10 PCTUSED 40 INITRANS 4 TABLESPACE DEMData"
RAS_INDEX_ID "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
BND_STORAGE "PCTFREE 10 PCTUSED 40 INITRANS 4 TABLESPACE GISData "
BND_INDEX_COMPOSITE "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
BND_INDEX_ID "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex"
AUX_STORAGE "PCTFREE 10 PCTUSED 40 INITRANS 4 TABLESPACE DEMData"
AUX_INDEX_COMPOSITE "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
BLK_STORAGE "PCTFREE 10 PCTUSED 40 INITRANS 4 TABLESPACE DEMData"
BLK_INDEX_COMPOSITE "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex "
XML_DOC_STORAGE "PCTFREE 10 PCTUSED 40 INITRANS 4 TABLESPACE DEMData"
XML_DOC_INDEX "PCTFREE 10 INITRANS 4 NOLOGGING TABLESPACE DEMIndex"
XML_DOC_LOB_STO