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"
XML_COLUMN_STORAGE		"SDE_XML"
XMLDB_INDEX_TAG       "YES"
XMLDB_INDEX_FULLTEXT  "NO"

END

注:

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