The DEFAULTS keyword in Oracle

As the name indicates, the settings under the DEFAULTS configuration keyword are used by default when you create tables, feature classes, raster datasets, and indexes. If you do not specify a different keyword when data is created in the geodatabase, or if you specify a keyword that is missing some necessary parameters, values from the DEFAULTS keyword are used.

You need to supply the information shown in brackets (<>) and uncomment the associated TABLESPACE lines by removing the # sign. The parameters grouped under the DEFAULTS keyword should be set to values that apply to most of the data in your geodatabase. If you do not uncomment the TABLESPACE lines and provide values, the data will be stored in the default tablespace of the user creating the data.

##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

NoteNote:

The UNICODE_STRING parameter is not present by default. However, new ArcSDE geodatabases for Oracle use Unicode encoding. To change this, you must add the UNICODE_STRING parameter to the DBTUNE table and set it to FALSE.

Related Topics


8/19/2013