Oracle DATA DICTIONARY keyword
Oracle DATA DICTIONARY keyword
|
| Release 9.3 |
   |
Most geodatabases in Oracle will not require more than one tablespace for the ArcSDE data dictionary 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 data dictionary 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 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 prior to creating 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
