The DATA_DICTIONARY keyword in Oracle

The DATA_DICTIONARY keyword contains parameters that determine the storage settings for specific ArcSDE geodatabase system tables.

Most geodatabases in Oracle do not require more than one tablespace for the ArcSDE repository tables. However, if you anticipate the need to manage space for the following segments independently of the rest of the ArcSDE system tables, create one or more tablespaces for those segments when you create your Oracle database. If you do create additional tablespaces, place them on a fast storage volume such as RAID 10.

If you want to store business tables and indexes, states tables and indexes, and/or ArcSDE XML tables and indexes in different tablespaces, uncomment the appropriate TABLESPACE line or lines in the dbtune.sde file and type your tablespace names in the line before you create your geodatabase.

##DATA_DICTIONARY
ATTRIBUTE_BINARY		"BLOB"
B_STORAGE               "PCTFREE 0 INITRANS 4 
#TABLESPACE <Business table tablespace name>
                         STORAGE (INITIAL 40K)"
B_INDEX_ROWID           "PCTFREE 0 INITRANS 4
#TABLESPACE <Data_dictionary index tablespace name> 
                         STORAGE (INITIAL 40K) NOLOGGING"
B_INDEX_USER            "PCTFREE 0 INITRANS 4 
#TABLESPACE <Data_dictionary index tablespace name> 
                         STORAGE (INITIAL 40K) NOLOGGING"

STATES_TABLE            "INITRANS 4
# TABLESPACE <STATES table tablespace name>
                         STORAGE (INITIAL 1M)"
STATES_INDEX            "INITRANS 5
#TABLESPACE <STATES table's index tablespace name> 
                         STORAGE (INITIAL 128K) NOLOGGING"

STATE_LINEAGES_TABLE    "PCTFREE 0 INITRANS 4
#TABLESPACE <STATE_LINEAGES(IOT) table's index tablespace name>
                         STORAGE (INITIAL 7M)"

STATE_LINEAGES_INDEX    "PCTFREE 0 INITRANS 4
#TABLESPACE <table's index tablespace name>
                         STORAGE (INITIAL 5M) NOLOGGING"

VERSIONS_TABLE          "INITRANS 4
#TABLESPACE <VERSIONS table tablespace name>
                         STORAGE (INITIAL 256K)"
VERSIONS_INDEX          "INITRANS 4
#TABLESPACE <VERSIONS table's index tablespace name>
                         STORAGE (INITIAL 128K) NOLOGGING"

MVTABLES_MODIFIED_TABLE "INITRANS 4
#TABLESPACE <MVTABLES_MODIFIED table tablespace name>
                         STORAGE (INITIAL 2M)"
MVTABLES_MODIFIED_INDEX "INITRANS 4 
#TABLESPACE <MVTABLES_MODIFIED table's index tablespace name>
                         STORAGE (INITIAL  2M) NOLOGGING"

XML_INDEX_TAGS_TABLE    "INITRANS 4
#TABLESPACE <XML_INDEX_TAGS table tablespace name>
                         STORAGE (INITIAL 1M)"
XML_INDEX_TAGS_INDEX    "INITRANS 5
#TABLESPACE <XML_INDEX_TAGS table's index tablespace name>
                         STORAGE (INITIAL 1M)"
END

Related Topics


11/18/2013