Oracle 中的 DEFAULTS 关键字

顾名思义,在创建表、要素类、栅格数据集以及索引时,默认情况下使用 DEFAULTS 配置关键字下的设置。如果在地理数据库中创建数据时未指定其他关键字,或者指定的关键字缺少某些必要参数,则将使用 DEFAULTS 关键字中的值。

您需要提供在方括号 (<>) 中显示的信息,并移除 # 符号取消关联 TABLESPACE 行的注释。对于归属于 DEFAULTS 关键字的参数,所设置的参数值应适用于地理数据库中的多数数据。如果不取消 TABLESPACE 行的注释,也不提供相关值,则数据将存储在创建数据用户的默认表空间中。

##DEFAULTS GEOMETRY_STORAGE  "ST_GEOMETRY" ATTRIBUTE_BINARY        "BLOB" RASTER_STORAGE "BLOB" ST_GEOM_LOB_STORAGE  "STORE AS ( # TABLESPACE <lob segment tablespace_name>   ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE)"  B_INDEX_RASTER "PCTFREE 0 INITRANS 4  #	TABLESPACE <default index tablespace name>  		NOLOGGING" B_INDEX_ROWID   "PCTFREE 0 INITRANS 4  #	TABLESPACE <default index tablespace name>  		NOLOGGING" B_INDEX_TO_DATE "PCTFREE 0 INITRANS 4  #	TABLESPACE <default index tablespace name>  		NOLOGGING" B_INDEX_USER    "PCTFREE 0 INITRANS 4  #	TABLESPACE <default index tablespace name>  		NOLOGGING" B_INDEX_XML     "PCTFREE 0 INITRANS 4  #	TABLESPACE <default index tablespace name>  		NOLOGGING" B_STORAGE       "PCTFREE 0 INITRANS 4  #	TABLESPACE <default business table tablespace name>"  S_INDEX_ALL     "PCTFREE 0 INITRANS 4  #	TABLESPACE <default index tablespace name>  		NOLOGGING" S_STORAGE       "PCTFREE 0 INITRANS 4  #	TABLESPACE <default spatial index table  tablespace name>"  A_INDEX_RASTER "PCTFREE 0 INITRANS 4  #	TABLESPACE <ADDS Table default index tablespace name>  		NOLOGGING" A_INDEX_ROWID   "PCTFREE 0 INITRANS 4  #	TABLESPACE <ADDS Table default index tablespace name>  		NOLOGGING" A_INDEX_SHAPE   "PCTFREE 0 INITRANS 4  #TABLESPACE <ADDS Table default index tablespace name>  NOLOGGING" A_INDEX_STATEID "PCTFREE 0 INITRANS 4  #	TABLESPACE <ADDS Table default index tablespace name>  		NOLOGGING" A_INDEX_USER    "PCTFREE 0 INITRANS 4  #	TABLESPACE <ADDS Table default index tablespace name>  		NOLOGGING" A_INDEX_XML "PCTFREE 0 INITRANS 4  #	TABLESPACE <ADDS Table default index tablespace name>  		NOLOGGING" A_STORAGE       "PCTFREE 0  INITRANS 4  #	TABLESPACE <default ADDS table tablespace name>"  D_INDEX_DELETED_AT      "PCTFREE 0 INITRANS 4  #	TABLESPACE <DELETES table default index tablespace name>  		NOLOGGING" D_INDEX_STATE_ROWID     "PCTFREE 0 INITRANS 4  #	TABLESPACE <DELETES table default index tablespace name>  		NOLOGGING" D_STORAGE       "PCTFREE 0 INITRANS 4  #	TABLESPACE <default DELETES table tablespace name>"  RAS_INDEX_ID    "PCTFREE 0 INITRANS 4  #	TABLESPACE <RAS tablespace name>  		NOLOGGING" RAS_STORAGE	    "PCTFREE 0 INITRANS 4  #	TABLESPACE <RAS tablespace name>"  BND_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4  #	TABLESPACE <RAS Table tablespace name>  		NOLOGGING" BND_INDEX_ID    "PCTFREE 0 INITRANS 4  #	TABLESPACE <RAS Table tablespace name>  		NOLOGGING" BND_STORAGE     "PCTFREE 0 INITRANS 4  #	TABLESPACE <RAS Table tablespace name>"  AUX_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4  #	TABLESPACE <RAS Table tablespace name>  		NOLOGGING" AUX_STORAGE	    "PCTFREE 0 INITRANS 4  #	TABLESPACE <RAS Table tablespace name>"  BLK_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4  #	TABLESPACE <RAS Table tablespace name>  		NOLOGGING" BLK_STORAGE     "PCTFREE 0 INITRANS 4  #	TABLESPACE <RAS Table tablespace name>"   LOB(BLOCK_DATA) STORE AS ( # TABLESPACE <lob segment tablespace_name> ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE)"  UI_TEXT 	    "User interface text for DEFAULTS"  XML_DOC_UNCOMPRESSED_TYPE   "CLOB" XML_IDX_TEXT_UPDATE_METHOD "NONE" XML_DOC_MODE  "COMPRESSED" XML_DOC_LOB_STORAGE "NOCACHE NOLOGGING CHUNK 4K PCTVERSION 5 DISABLE STORAGE IN ROW  #	TABLESPACE <XML LOB tablespace name>" XML_DOC_VAL_LOB_STORAGE "NOCACHE NOLOGGING CHUNK 4K PCTVERSION 5 DISABLE STORAGE IN ROW  #	TABLESPACE <XML LOB tablespace name>" XML_DOC_STORAGE "PCTFREE 0 INITRANS 4  #	TABLESPACE <XML tablespace name>" XML_DOC_INDEX   "PCTFREE 0 INITRANS 4 NOLOGGING  #	TABLESPACE <XML tablespace name>" NOLOGGING XML_IDX_STORAGE "PCTFREE 0 INITRANS 4" # TABLESPACE <XML tablespace name> XML_IDX_TEXT_TAG_STORAGE "" XML_IDX_INDEX_PK "PCTFREE 0 INITRANS 4  #	TABLESPACE <XML tablespace name>  		NOLOGGING" XML_IDX_INDEX_ID "PCTFREE 0 INITRANS 4  #	TABLESPACE <XML tablespace name>  		NOLOGGING" XML_IDX_TEXT_TAG_STORAGE   "" XML_IDX_INDEX_PK    "PCTFREE 0 INITRANS 4 # TABLESPACE <XML tablespace name>   NOLOGGING" XML_IDX_INDEX_ID    "PCTFREE 0 INITRANS 4 # TABLESPACE <XML tablespace name>   NOLOGGING" XML_IDX_INDEX_TEXT  "" XML_IDX_TEXT_UPDATE_MEMORY "" XML_IDX_INDEX_TAG "PCTFREE 0 INITRANS 4  #	TABLESPACE <XML tablespace name>  		NOLOGGING" XML_IDX_INDEX_DOUBLE "PCTFREE 0 INITRANS 4  #	TABLESPACE <XML tablespace name>  		NOLOGGING" XML_IDX_INDEX_STRING "PCTFREE 0 INITRANS 4 #	TABLESPACE <XML tablespace name>  		NOLOGGING" XMLCOLUMN_STORAGE		"DB_XML" XMLDB_INDEX_TAG       "YES" XMLDB_INDEX_FULLTEXT  "NO"  END

注注:

UNICODE_STRING 参数默认不存在。但是,Oracle 新的 ArcSDE 地理数据库将使用 Unicode 编码。要更改此设置,必须将 UNICODE_STRING 参数添加至 DBTUNE 表并将其设置为 FALSE。

相关主题


7/10/2012